Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 239677 |
| Missing cells | 1263226 |
| Missing cells (%) | 18.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 51.4 MiB |
| Average record size in memory | 225.0 B |
Variable types
| Numeric | 9 |
|---|---|
| DateTime | 1 |
| Text | 18 |
| Boolean | 1 |
incident_url_fields_missing has constant value "" | Constant |
state_house_district is highly overall correlated with state_senate_district | High correlation |
state_senate_district is highly overall correlated with state_house_district | High correlation |
address has 16497 (6.9%) missing values | Missing |
congressional_district has 11944 (5.0%) missing values | Missing |
gun_stolen has 99498 (41.5%) missing values | Missing |
gun_type has 99451 (41.5%) missing values | Missing |
latitude has 7923 (3.3%) missing values | Missing |
location_description has 197588 (82.4%) missing values | Missing |
longitude has 7923 (3.3%) missing values | Missing |
n_guns_involved has 99451 (41.5%) missing values | Missing |
notes has 81017 (33.8%) missing values | Missing |
participant_age has 92298 (38.5%) missing values | Missing |
participant_age_group has 42119 (17.6%) missing values | Missing |
participant_gender has 36362 (15.2%) missing values | Missing |
participant_name has 122253 (51.0%) missing values | Missing |
participant_relationship has 223903 (93.4%) missing values | Missing |
participant_status has 27626 (11.5%) missing values | Missing |
participant_type has 24863 (10.4%) missing values | Missing |
state_house_district has 38772 (16.2%) missing values | Missing |
state_senate_district has 32335 (13.5%) missing values | Missing |
n_guns_involved is highly skewed (γ1 = 51.5950726) | Skewed |
incident_id has unique values | Unique |
incident_url has unique values | Unique |
n_killed has 185835 (77.5%) zeros | Zeros |
n_injured has 142487 (59.4%) zeros | Zeros |
Reproduction
| Analysis started | 2023-11-25 21:18:32.577077 |
|---|---|
| Analysis finished | 2023-11-25 21:19:21.453578 |
| Duration | 48.88 seconds |
| Software version | ydata-profiling vv4.6.2 |
| Download configuration | config.json |
incident_id
Real number (ℝ)
UNIQUE 
| Distinct | 239677 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 559334.35 |
| Minimum | 92114 |
|---|---|
| Maximum | 1083472 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 92114 |
|---|---|
| 5-th percentile | 126858.6 |
| Q1 | 308545 |
| median | 543587 |
| Q3 | 817228 |
| 95-th percentile | 1028801.6 |
| Maximum | 1083472 |
| Range | 991358 |
| Interquartile range (IQR) | 508683 |
Descriptive statistics
| Standard deviation | 293128.68 |
|---|---|
| Coefficient of variation (CV) | 0.52406702 |
| Kurtosis | -1.2241713 |
| Mean | 559334.35 |
| Median Absolute Deviation (MAD) | 253242 |
| Skewness | 0.095167904 |
| Sum | 1.3405958 × 1011 |
| Variance | 8.5924426 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 461105 | 1 | < 0.1% |
| 717982 | 1 | < 0.1% |
| 718485 | 1 | < 0.1% |
| 718520 | 1 | < 0.1% |
| 719602 | 1 | < 0.1% |
| 718791 | 1 | < 0.1% |
| 717783 | 1 | < 0.1% |
| 717393 | 1 | < 0.1% |
| 717685 | 1 | < 0.1% |
| 719638 | 1 | < 0.1% |
| Other values (239667) | 239667 |
| Value | Count | Frequency (%) |
| 92114 | 1 | |
| 92117 | 1 | |
| 92119 | 1 | |
| 92122 | 1 | |
| 92125 | 1 | |
| 92129 | 1 | |
| 92131 | 1 | |
| 92133 | 1 | |
| 92135 | 1 | |
| 92137 | 1 |
| Value | Count | Frequency (%) |
| 1083472 | 1 | |
| 1083466 | 1 | |
| 1083457 | 1 | |
| 1083435 | 1 | |
| 1083428 | 1 | |
| 1083413 | 1 | |
| 1083396 | 1 | |
| 1083390 | 1 | |
| 1083389 | 1 | |
| 1083379 | 1 |
date
Date
| Distinct | 1725 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Minimum | 2013-01-01 00:00:00 |
|---|---|
| Maximum | 2018-03-31 00:00:00 |
state
Text
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 13 |
| Mean length | 8.6643107 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2076636 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Pennsylvania |
|---|---|
| 2nd row | California |
| 3rd row | Ohio |
| 4th row | Colorado |
| 5th row | North Carolina |
| Value | Count | Frequency (%) |
| new | 17708 | 6.3% |
| illinois | 17556 | 6.2% |
| california | 16306 | 5.8% |
| carolina | 15678 | 5.5% |
| florida | 15029 | 5.3% |
| texas | 13577 | 4.8% |
| ohio | 10244 | 3.6% |
| york | 9712 | 3.4% |
| north | 9312 | 3.3% |
| pennsylvania | 8929 | 3.2% |
| Other values (45) | 148989 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 256726 | |
| i | 246073 | |
| n | 176038 | 8.5% |
| o | 171176 | 8.2% |
| s | 155405 | 7.5% |
| e | 121747 | 5.9% |
| r | 118926 | 5.7% |
| l | 116103 | 5.6% |
| t | 56154 | 2.7% |
| h | 49637 | 2.4% |
| Other values (36) | 608651 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1753428 | |
| Uppercase Letter | 279845 | 13.5% |
| Space Separator | 43363 | 2.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 256726 | |
| i | 246073 | |
| n | 176038 | |
| o | 171176 | |
| s | 155405 | |
| e | 121747 | |
| r | 118926 | |
| l | 116103 | |
| t | 56154 | 3.2% |
| h | 49637 | 2.8% |
| Other values (14) | 285443 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 41447 | |
| M | 33743 | |
| N | 30623 | |
| I | 27481 | |
| T | 21203 | 7.6% |
| O | 15985 | 5.7% |
| F | 15029 | 5.4% |
| A | 11990 | 4.3% |
| W | 10290 | 3.7% |
| Y | 9712 | 3.5% |
| Other values (11) | 62342 |
Space Separator
| Value | Count | Frequency (%) |
| 43363 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2033273 | |
| Common | 43363 | 2.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 256726 | |
| i | 246073 | |
| n | 176038 | 8.7% |
| o | 171176 | 8.4% |
| s | 155405 | 7.6% |
| e | 121747 | 6.0% |
| r | 118926 | 5.8% |
| l | 116103 | 5.7% |
| t | 56154 | 2.8% |
| h | 49637 | 2.4% |
| Other values (35) | 565288 |
Common
| Value | Count | Frequency (%) |
| 43363 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2076636 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 256726 | |
| i | 246073 | |
| n | 176038 | 8.5% |
| o | 171176 | 8.2% |
| s | 155405 | 7.5% |
| e | 121747 | 5.9% |
| r | 118926 | 5.7% |
| l | 116103 | 5.6% |
| t | 56154 | 2.7% |
| h | 49637 | 2.4% |
| Other values (36) | 608651 |
city_or_county
Text
| Distinct | 12898 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 43 |
| Mean length | 9.3553658 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2242266 |
|---|---|
| Distinct characters | 59 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 5031 ? |
|---|---|
| Unique (%) | 2.1% |
Sample
| 1st row | Mckeesport |
|---|---|
| 2nd row | Hawthorne |
| 3rd row | Lorain |
| 4th row | Aurora |
| 5th row | Greensboro |
| Value | Count | Frequency (%) |
| chicago | 11796 | 3.8% |
| city | 6413 | 2.1% |
| county | 6348 | 2.0% |
| new | 5148 | 1.7% |
| saint | 4315 | 1.4% |
| baltimore | 3966 | 1.3% |
| washington | 3401 | 1.1% |
| san | 3353 | 1.1% |
| orleans | 3157 | 1.0% |
| beach | 2994 | 1.0% |
| Other values (8671) | 258802 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 200004 | 8.9% |
| o | 181617 | 8.1% |
| e | 181294 | 8.1% |
| n | 168763 | 7.5% |
| i | 152407 | 6.8% |
| l | 137985 | 6.2% |
| t | 123954 | 5.5% |
| r | 117309 | 5.2% |
| s | 98636 | 4.4% |
| 70150 | 3.1% | |
| Other values (49) | 810147 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1842443 | |
| Uppercase Letter | 306110 | 13.7% |
| Space Separator | 70150 | 3.1% |
| Close Punctuation | 11462 | 0.5% |
| Open Punctuation | 11462 | 0.5% |
| Dash Punctuation | 512 | < 0.1% |
| Other Punctuation | 127 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 200004 | |
| o | 181617 | |
| e | 181294 | |
| n | 168763 | |
| i | 152407 | 8.3% |
| l | 137985 | 7.5% |
| t | 123954 | 6.7% |
| r | 117309 | 6.4% |
| s | 98636 | 5.4% |
| h | 62169 | 3.4% |
| Other values (17) | 418305 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 44556 | |
| S | 27436 | 9.0% |
| B | 26681 | 8.7% |
| M | 21634 | 7.1% |
| L | 20173 | 6.6% |
| P | 19538 | 6.4% |
| A | 15128 | 4.9% |
| W | 14652 | 4.8% |
| H | 14198 | 4.6% |
| R | 12615 | 4.1% |
| Other values (16) | 89499 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 74 | |
| . | 53 |
Space Separator
| Value | Count | Frequency (%) |
| 70150 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 11462 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 11462 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 512 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2148553 | |
| Common | 93713 | 4.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 200004 | 9.3% |
| o | 181617 | 8.5% |
| e | 181294 | 8.4% |
| n | 168763 | 7.9% |
| i | 152407 | 7.1% |
| l | 137985 | 6.4% |
| t | 123954 | 5.8% |
| r | 117309 | 5.5% |
| s | 98636 | 4.6% |
| h | 62169 | 2.9% |
| Other values (43) | 724415 |
Common
| Value | Count | Frequency (%) |
| 70150 | ||
| ) | 11462 | 12.2% |
| ( | 11462 | 12.2% |
| - | 512 | 0.5% |
| ' | 74 | 0.1% |
| . | 53 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2242261 | |
| None | 5 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 200004 | 8.9% |
| o | 181617 | 8.1% |
| e | 181294 | 8.1% |
| n | 168763 | 7.5% |
| i | 152407 | 6.8% |
| l | 137985 | 6.2% |
| t | 123954 | 5.5% |
| r | 117309 | 5.2% |
| s | 98636 | 4.4% |
| 70150 | 3.1% | |
| Other values (48) | 810142 |
None
| Value | Count | Frequency (%) |
| ñ | 5 |
address
Text
MISSING 
| Distinct | 198037 |
|---|---|
| Distinct (%) | 88.7% |
| Missing | 16497 |
| Missing (%) | 6.9% |
| Memory size | 1.8 MiB |
Length
| Max length | 97 |
|---|---|
| Median length | 74 |
| Mean length | 22.465454 |
| Min length | 2 |
Characters and Unicode
| Total characters | 5013840 |
|---|---|
| Distinct characters | 93 |
| Distinct categories | 15 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 4 ? |
Unique
| Unique | 184863 ? |
|---|---|
| Unique (%) | 82.8% |
Sample
| 1st row | 1506 Versailles Avenue and Coursin Street |
|---|---|
| 2nd row | 13500 block of Cerise Avenue |
| 3rd row | 1776 East 28th Street |
| 4th row | 16000 block of East Ithaca Place |
| 5th row | 307 Mourning Dove Terrace |
| Value | Count | Frequency (%) |
| block | 83046 | 8.7% |
| of | 82994 | 8.7% |
| street | 47009 | 4.9% |
| and | 34826 | 3.6% |
| avenue | 32127 | 3.4% |
| st | 31940 | 3.3% |
| ave | 21322 | 2.2% |
| road | 20226 | 2.1% |
| drive | 12957 | 1.4% |
| rd | 12369 | 1.3% |
| Other values (39852) | 577061 |
Most occurring characters
| Value | Count | Frequency (%) |
| 738367 | 14.7% | |
| e | 390118 | 7.8% |
| o | 333685 | 6.7% |
| t | 282064 | 5.6% |
| 0 | 234554 | 4.7% |
| a | 228926 | 4.6% |
| r | 224218 | 4.5% |
| n | 206961 | 4.1% |
| l | 198571 | 4.0% |
| d | 133862 | 2.7% |
| Other values (83) | 2042514 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3039003 | |
| Space Separator | 738369 | 14.7% |
| Decimal Number | 624340 | 12.5% |
| Uppercase Letter | 589521 | 11.8% |
| Other Punctuation | 19718 | 0.4% |
| Dash Punctuation | 2721 | 0.1% |
| Final Punctuation | 106 | < 0.1% |
| Open Punctuation | 21 | < 0.1% |
| Close Punctuation | 20 | < 0.1% |
| Other Number | 12 | < 0.1% |
| Other values (5) | 9 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 390118 | |
| o | 333685 | |
| t | 282064 | 9.3% |
| a | 228926 | 7.5% |
| r | 224218 | 7.4% |
| n | 206961 | 6.8% |
| l | 198571 | 6.5% |
| d | 133862 | 4.4% |
| i | 121302 | 4.0% |
| c | 117620 | 3.9% |
| Other values (19) | 801676 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 125002 | |
| A | 67805 | |
| R | 45933 | 7.8% |
| W | 36913 | 6.3% |
| C | 34134 | 5.8% |
| B | 32824 | 5.6% |
| D | 30559 | 5.2% |
| N | 29319 | 5.0% |
| E | 27076 | 4.6% |
| M | 23763 | 4.0% |
| Other values (16) | 136193 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 234554 | |
| 1 | 89287 | 14.3% |
| 2 | 59061 | 9.5% |
| 3 | 46263 | 7.4% |
| 5 | 41835 | 6.7% |
| 4 | 40154 | 6.4% |
| 6 | 31171 | 5.0% |
| 7 | 30002 | 4.8% |
| 8 | 26838 | 4.3% |
| 9 | 25175 | 4.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 18286 | |
| , | 582 | 3.0% |
| ' | 314 | 1.6% |
| / | 281 | 1.4% |
| # | 124 | 0.6% |
| & | 106 | 0.5% |
| ; | 18 | 0.1% |
| " | 6 | < 0.1% |
| \ | 1 | < 0.1% |
Format
| Value | Count | Frequency (%) |
| | 2 | |
| | 1 | |
| | 1 | |
| | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 738367 | ||
| 2 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2720 | |
| – | 1 | < 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 20 | |
| [ | 1 | 4.8% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 19 | |
| ] | 1 | 5.0% |
Other Number
| Value | Count | Frequency (%) |
| ½ | 11 | |
| ¼ | 1 | 8.3% |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 106 |
Line Separator
| Value | Count | Frequency (%) |
| 1 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 1 |
Initial Punctuation
| Value | Count | Frequency (%) |
| ‘ | 1 |
Modifier Letter
| Value | Count | Frequency (%) |
| ʻ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3628524 | |
| Common | 1385316 | 27.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 390118 | 10.8% |
| o | 333685 | 9.2% |
| t | 282064 | 7.8% |
| a | 228926 | 6.3% |
| r | 224218 | 6.2% |
| n | 206961 | 5.7% |
| l | 198571 | 5.5% |
| d | 133862 | 3.7% |
| S | 125002 | 3.4% |
| i | 121302 | 3.3% |
| Other values (45) | 1383815 |
Common
| Value | Count | Frequency (%) |
| 738367 | ||
| 0 | 234554 | 16.9% |
| 1 | 89287 | 6.4% |
| 2 | 59061 | 4.3% |
| 3 | 46263 | 3.3% |
| 5 | 41835 | 3.0% |
| 4 | 40154 | 2.9% |
| 6 | 31171 | 2.3% |
| 7 | 30002 | 2.2% |
| 8 | 26838 | 1.9% |
| Other values (28) | 47784 | 3.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5013583 | |
| None | 145 | < 0.1% |
| Punctuation | 111 | < 0.1% |
| Modifier Letters | 1 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 738367 | 14.7% | |
| e | 390118 | 7.8% |
| o | 333685 | 6.7% |
| t | 282064 | 5.6% |
| 0 | 234554 | 4.7% |
| a | 228926 | 4.6% |
| r | 224218 | 4.5% |
| n | 206961 | 4.1% |
| l | 198571 | 4.0% |
| d | 133862 | 2.7% |
| Other values (68) | 2042257 |
None
| Value | Count | Frequency (%) |
| ñ | 126 | |
| ½ | 11 | 7.6% |
| 2 | 1.4% | |
| | 2 | 1.4% |
| ¼ | 1 | 0.7% |
| é | 1 | 0.7% |
| | 1 | 0.7% |
| í | 1 | 0.7% |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 106 | |
| 1 | 0.9% | |
| ‘ | 1 | 0.9% |
| | 1 | 0.9% |
| – | 1 | 0.9% |
| | 1 | 0.9% |
Modifier Letters
| Value | Count | Frequency (%) |
| ʻ | 1 |
n_killed
Real number (ℝ)
ZEROS 
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.25228954 |
| Minimum | 0 |
|---|---|
| Maximum | 50 |
| Zeros | 185835 |
| Zeros (%) | 77.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.52177887 |
|---|---|
| Coefficient of variation (CV) | 2.0681748 |
| Kurtosis | 390.58532 |
| Mean | 0.25228954 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.636379 |
| Sum | 60468 |
| Variance | 0.27225319 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 185835 | |
| 1 | 48436 | 20.2% |
| 2 | 4604 | 1.9% |
| 3 | 595 | 0.2% |
| 4 | 139 | 0.1% |
| 5 | 41 | < 0.1% |
| 6 | 11 | < 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| Other values (6) | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 185835 | |
| 1 | 48436 | 20.2% |
| 2 | 4604 | 1.9% |
| 3 | 595 | 0.2% |
| 4 | 139 | 0.1% |
| 5 | 41 | < 0.1% |
| 6 | 11 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 50 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| 16 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 3 | < 0.1% |
| 8 | 5 | |
| 7 | 2 | < 0.1% |
| 6 | 11 |
n_injured
Real number (ℝ)
ZEROS 
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.49400652 |
| Minimum | 0 |
|---|---|
| Maximum | 53 |
| Zeros | 142487 |
| Zeros (%) | 59.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 53 |
| Range | 53 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.72995227 |
|---|---|
| Coefficient of variation (CV) | 1.4776167 |
| Kurtosis | 142.82674 |
| Mean | 0.49400652 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.4433995 |
| Sum | 118402 |
| Variance | 0.53283032 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 142487 | |
| 1 | 81986 | |
| 2 | 11484 | 4.8% |
| 3 | 2513 | 1.0% |
| 4 | 760 | 0.3% |
| 5 | 241 | 0.1% |
| 6 | 91 | < 0.1% |
| 7 | 51 | < 0.1% |
| 8 | 19 | < 0.1% |
| 9 | 12 | < 0.1% |
| Other values (13) | 33 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 142487 | |
| 1 | 81986 | |
| 2 | 11484 | 4.8% |
| 3 | 2513 | 1.0% |
| 4 | 760 | 0.3% |
| 5 | 241 | 0.1% |
| 6 | 91 | < 0.1% |
| 7 | 51 | < 0.1% |
| 8 | 19 | < 0.1% |
| 9 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 53 | 1 | < 0.1% |
| 25 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 19 | 3 | |
| 18 | 1 | < 0.1% |
| 17 | 2 | |
| 16 | 2 | |
| 15 | 2 | |
| 14 | 3 | |
| 13 | 2 |
incident_url
Text
UNIQUE 
| Distinct | 239677 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 50 |
|---|---|
| Median length | 49 |
| Mean length | 49.067921 |
| Min length | 48 |
Characters and Unicode
| Total characters | 11760452 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 239677 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | http://www.gunviolencearchive.org/incident/461105 |
|---|---|
| 2nd row | http://www.gunviolencearchive.org/incident/460726 |
| 3rd row | http://www.gunviolencearchive.org/incident/478855 |
| 4th row | http://www.gunviolencearchive.org/incident/478925 |
| 5th row | http://www.gunviolencearchive.org/incident/478959 |
| Value | Count | Frequency (%) |
| http://www.gunviolencearchive.org/incident/461105 | 1 | < 0.1% |
| http://www.gunviolencearchive.org/incident/479561 | 1 | < 0.1% |
| http://www.gunviolencearchive.org/incident/481198 | 1 | < 0.1% |
| http://www.gunviolencearchive.org/incident/481186 | 1 | < 0.1% |
| http://www.gunviolencearchive.org/incident/478855 | 1 | < 0.1% |
| http://www.gunviolencearchive.org/incident/478925 | 1 | < 0.1% |
| http://www.gunviolencearchive.org/incident/478959 | 1 | < 0.1% |
| http://www.gunviolencearchive.org/incident/478948 | 1 | < 0.1% |
| http://www.gunviolencearchive.org/incident/479363 | 1 | < 0.1% |
| http://www.gunviolencearchive.org/incident/479374 | 1 | < 0.1% |
| Other values (239667) | 239667 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 958708 | 8.2% |
| / | 958708 | 8.2% |
| i | 958708 | 8.2% |
| n | 958708 | 8.2% |
| c | 719031 | 6.1% |
| w | 719031 | 6.1% |
| t | 719031 | 6.1% |
| v | 479354 | 4.1% |
| r | 479354 | 4.1% |
| o | 479354 | 4.1% |
| Other values (19) | 4330465 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8628372 | |
| Other Punctuation | 1677739 | 14.3% |
| Decimal Number | 1454341 | 12.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 958708 | |
| i | 958708 | |
| n | 958708 | |
| c | 719031 | |
| w | 719031 | |
| t | 719031 | |
| v | 479354 | 5.6% |
| r | 479354 | 5.6% |
| o | 479354 | 5.6% |
| h | 479354 | 5.6% |
| Other values (6) | 1677739 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 175661 | |
| 3 | 144114 | |
| 4 | 143086 | |
| 9 | 142610 | |
| 2 | 142412 | |
| 7 | 141844 | |
| 8 | 141706 | |
| 5 | 141440 | |
| 6 | 141246 | |
| 0 | 140222 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 958708 | |
| . | 479354 | |
| : | 239677 | 14.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8628372 | |
| Common | 3132080 | 26.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 958708 | |
| i | 958708 | |
| n | 958708 | |
| c | 719031 | |
| w | 719031 | |
| t | 719031 | |
| v | 479354 | 5.6% |
| r | 479354 | 5.6% |
| o | 479354 | 5.6% |
| h | 479354 | 5.6% |
| Other values (6) | 1677739 |
Common
| Value | Count | Frequency (%) |
| / | 958708 | |
| . | 479354 | |
| : | 239677 | 7.7% |
| 1 | 175661 | 5.6% |
| 3 | 144114 | 4.6% |
| 4 | 143086 | 4.6% |
| 9 | 142610 | 4.6% |
| 2 | 142412 | 4.5% |
| 7 | 141844 | 4.5% |
| 8 | 141706 | 4.5% |
| Other values (3) | 422908 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11760452 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 958708 | 8.2% |
| / | 958708 | 8.2% |
| i | 958708 | 8.2% |
| n | 958708 | 8.2% |
| c | 719031 | 6.1% |
| w | 719031 | 6.1% |
| t | 719031 | 6.1% |
| v | 479354 | 4.1% |
| r | 479354 | 4.1% |
| o | 479354 | 4.1% |
| Other values (19) | 4330465 |
source_url
Text
| Distinct | 213989 |
|---|---|
| Distinct (%) | 89.5% |
| Missing | 468 |
| Missing (%) | 0.2% |
| Memory size | 1.8 MiB |
Length
| Max length | 255 |
|---|---|
| Median length | 225 |
| Mean length | 94.044463 |
| Min length | 2 |
Characters and Unicode
| Total characters | 22496282 |
|---|---|
| Distinct characters | 94 |
| Distinct categories | 15 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 203257 ? |
|---|---|
| Unique (%) | 85.0% |
Sample
| 1st row | http://www.post-gazette.com/local/south/2013/01/17/Man-arrested-in-New-Year-s-Eve-shooting-in-McKeesport/stories/201301170275 |
|---|---|
| 2nd row | http://www.dailybulletin.com/article/zz/20130105/NEWS/130109127 |
| 3rd row | http://chronicle.northcoastnow.com/2013/02/14/2-men-indicted-in-new-years-day-lorain-murder/ |
| 4th row | http://www.dailydemocrat.com/20130106/aurora-shootout-killer-was-frenetic-talented-neighbor-says |
| 5th row | http://www.journalnow.com/news/local/article_d4c723e8-5a0f-11e2-a1fa-0019bb30f31a.html |
| Value | Count | Frequency (%) |
| http://blog.tsa.gov | 1179 | 0.5% |
| http://callsforservice.jaxsheriff.org | 811 | 0.3% |
| https://data.oaklandnet.com/public-safety/crimewatch-maps-past-90-days/ym6k-rx7a | 492 | 0.2% |
| http://itmdapps.ci.mil.wi.us/mpdcalldata/currentcadcalls/callsservice.faces | 330 | 0.1% |
| http://www.springsgov.com/units/police/policeblotter.asp | 243 | 0.1% |
| https://www.facebook.com/pg/policeclips/posts/?ref=page_internal | 126 | 0.1% |
| http://www.tampabay.com/news/hillsborough/crime | 107 | < 0.1% |
| http://blog.tsa.gov/2016 | 104 | < 0.1% |
| 05 | 104 | < 0.1% |
| http://blog.tsa.gov/search | 87 | < 0.1% |
| Other values (214167) | 236416 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 1546920 | 6.9% |
| - | 1531611 | 6.8% |
| e | 1493452 | 6.6% |
| / | 1449910 | 6.4% |
| o | 1302203 | 5.8% |
| n | 1132270 | 5.0% |
| s | 1056971 | 4.7% |
| a | 1016166 | 4.5% |
| i | 1007666 | 4.5% |
| r | 886137 | 3.9% |
| Other values (84) | 10072976 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 16120917 | |
| Other Punctuation | 2262946 | 10.1% |
| Decimal Number | 2249761 | 10.0% |
| Dash Punctuation | 1531611 | 6.8% |
| Uppercase Letter | 169431 | 0.8% |
| Connector Punctuation | 135869 | 0.6% |
| Math Symbol | 24724 | 0.1% |
| Space Separator | 868 | < 0.1% |
| Open Punctuation | 53 | < 0.1% |
| Close Punctuation | 52 | < 0.1% |
| Other values (5) | 50 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 1546920 | 9.6% |
| e | 1493452 | 9.3% |
| o | 1302203 | 8.1% |
| n | 1132270 | 7.0% |
| s | 1056971 | 6.6% |
| a | 1016166 | 6.3% |
| i | 1007666 | 6.3% |
| r | 886137 | 5.5% |
| w | 877439 | 5.4% |
| c | 847159 | 5.3% |
| Other values (16) | 4954534 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 19140 | 11.3% |
| P | 14192 | 8.4% |
| C | 12103 | 7.1% |
| N | 11233 | 6.6% |
| D | 10609 | 6.3% |
| M | 10029 | 5.9% |
| W | 9555 | 5.6% |
| A | 9217 | 5.4% |
| E | 8615 | 5.1% |
| F | 6755 | 4.0% |
| Other values (16) | 57983 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 1449910 | |
| . | 532780 | 23.5% |
| : | 240291 | 10.6% |
| # | 12123 | 0.5% |
| ? | 9391 | 0.4% |
| & | 8182 | 0.4% |
| % | 6791 | 0.3% |
| , | 2978 | 0.1% |
| ! | 341 | < 0.1% |
| ; | 128 | < 0.1% |
| Other values (5) | 31 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 379735 | |
| 0 | 363273 | |
| 2 | 325058 | |
| 5 | 183678 | |
| 3 | 183337 | |
| 4 | 176774 | |
| 6 | 171599 | |
| 7 | 169095 | |
| 8 | 150051 | 6.7% |
| 9 | 147161 | 6.5% |
Math Symbol
| Value | Count | Frequency (%) |
| = | 17395 | |
| + | 7286 | |
| ~ | 28 | 0.1% |
| | | 15 | 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 41 | |
| ( | 12 | 22.6% |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 40 | |
| ) | 12 | 23.1% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ^ | 9 | |
| ` | 4 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1531611 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 135869 |
Space Separator
| Value | Count | Frequency (%) |
| 868 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 18 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 11 |
Control
| Value | Count | Frequency (%) |
| 7 |
Initial Punctuation
| Value | Count | Frequency (%) |
| ‘ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 16290348 | |
| Common | 6205934 | 27.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 1546920 | 9.5% |
| e | 1493452 | 9.2% |
| o | 1302203 | 8.0% |
| n | 1132270 | 7.0% |
| s | 1056971 | 6.5% |
| a | 1016166 | 6.2% |
| i | 1007666 | 6.2% |
| r | 886137 | 5.4% |
| w | 877439 | 5.4% |
| c | 847159 | 5.2% |
| Other values (42) | 5123965 |
Common
| Value | Count | Frequency (%) |
| - | 1531611 | |
| / | 1449910 | |
| . | 532780 | 8.6% |
| 1 | 379735 | 6.1% |
| 0 | 363273 | 5.9% |
| 2 | 325058 | 5.2% |
| : | 240291 | 3.9% |
| 5 | 183678 | 3.0% |
| 3 | 183337 | 3.0% |
| 4 | 176774 | 2.8% |
| Other values (32) | 839487 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 22496261 | |
| Punctuation | 21 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 1546920 | 6.9% |
| - | 1531611 | 6.8% |
| e | 1493452 | 6.6% |
| / | 1449910 | 6.4% |
| o | 1302203 | 5.8% |
| n | 1132270 | 5.0% |
| s | 1056971 | 4.7% |
| a | 1016166 | 4.5% |
| i | 1007666 | 4.5% |
| r | 886137 | 3.9% |
| Other values (81) | 10072955 |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 18 | |
| • | 2 | 9.5% |
| ‘ | 1 | 4.8% |
incident_url_fields_missing
Boolean
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 234.2 KiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 239677 |
congressional_district
Real number (ℝ)
MISSING 
| Distinct | 54 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11944 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.0012646 |
| Minimum | 0 |
|---|---|
| Maximum | 53 |
| Zeros | 421 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 5 |
| Q3 | 10 |
| 95-th percentile | 26 |
| Maximum | 53 |
| Range | 53 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 8.4808348 |
|---|---|
| Coefficient of variation (CV) | 1.0599368 |
| Kurtosis | 5.169602 |
| Mean | 8.0012646 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 2.1063618 |
| Sum | 1822152 |
| Variance | 71.924559 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 36910 | |
| 2 | 26945 | |
| 3 | 20621 | 8.6% |
| 7 | 19709 | 8.2% |
| 4 | 18469 | 7.7% |
| 5 | 16512 | 6.9% |
| 9 | 9867 | 4.1% |
| 6 | 9388 | 3.9% |
| 8 | 7353 | 3.1% |
| 13 | 6175 | 2.6% |
| Other values (44) | 55784 | |
| (Missing) | 11944 | 5.0% |
| Value | Count | Frequency (%) |
| 0 | 421 | 0.2% |
| 1 | 36910 | |
| 2 | 26945 | |
| 3 | 20621 | |
| 4 | 18469 | |
| 5 | 16512 | |
| 6 | 9388 | 3.9% |
| 7 | 19709 | |
| 8 | 7353 | 3.1% |
| 9 | 9867 | 4.1% |
| Value | Count | Frequency (%) |
| 53 | 130 | 0.1% |
| 52 | 158 | 0.1% |
| 51 | 228 | |
| 50 | 116 | < 0.1% |
| 49 | 100 | < 0.1% |
| 48 | 119 | < 0.1% |
| 47 | 292 | |
| 46 | 251 | |
| 45 | 45 | < 0.1% |
| 44 | 421 |
gun_stolen
Text
MISSING 
| Distinct | 349 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 99498 |
| Missing (%) | 41.5% |
| Memory size | 1.8 MiB |
Length
| Max length | 5488 |
|---|---|
| Median length | 10 |
| Mean length | 14.563365 |
| Min length | 8 |
Characters and Unicode
| Total characters | 2041478 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 176 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 0::Unknown||1::Unknown |
|---|---|
| 2nd row | 0::Unknown||1::Unknown |
| 3rd row | 0::Unknown||1::Unknown |
| 4th row | 0::Unknown |
| 5th row | 0::Unknown |
| Value | Count | Frequency (%) |
| 0::unknown | 121310 | |
| 0::unknown||1::unknown | 6116 | 4.4% |
| 0::stolen | 4503 | 3.2% |
| 0::unknown||1::unknown||2::unknown | 1484 | 1.1% |
| 0::not-stolen | 1352 | 1.0% |
| 0::stolen||1::stolen | 719 | 0.5% |
| 0::unknown||1::unknown||2::unknown||3::unknown | 583 | 0.4% |
| 0::stolen||1::unknown | 375 | 0.3% |
| 0:unknown | 336 | 0.2% |
| 0::stolen||1::stolen||2::stolen | 294 | 0.2% |
| Other values (339) | 3107 | 2.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 538167 | |
| : | 384282 | |
| o | 194149 | 9.5% |
| U | 172912 | 8.5% |
| k | 172912 | 8.5% |
| w | 172912 | 8.5% |
| 0 | 143437 | 7.0% |
| | | 104279 | 5.1% |
| 1 | 25555 | 1.3% |
| t | 21237 | 1.0% |
| Other values (14) | 111636 | 5.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1140045 | |
| Other Punctuation | 384282 | 18.8% |
| Decimal Number | 218723 | 10.7% |
| Uppercase Letter | 192343 | 9.4% |
| Math Symbol | 104279 | 5.1% |
| Dash Punctuation | 1806 | 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 143437 | |
| 1 | 25555 | 11.7% |
| 2 | 13189 | 6.0% |
| 3 | 8672 | 4.0% |
| 4 | 6170 | 2.8% |
| 5 | 5115 | 2.3% |
| 6 | 4688 | 2.1% |
| 7 | 4256 | 1.9% |
| 8 | 3942 | 1.8% |
| 9 | 3699 | 1.7% |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 538167 | |
| o | 194149 | 17.0% |
| k | 172912 | 15.2% |
| w | 172912 | 15.2% |
| t | 21237 | 1.9% |
| l | 19431 | 1.7% |
| e | 19431 | 1.7% |
| s | 1806 | 0.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 172912 | |
| S | 17625 | 9.2% |
| N | 1806 | 0.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 384282 |
Math Symbol
| Value | Count | Frequency (%) |
| | | 104279 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1806 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1332388 | |
| Common | 709090 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| : | 384282 | |
| 0 | 143437 | 20.2% |
| | | 104279 | 14.7% |
| 1 | 25555 | 3.6% |
| 2 | 13189 | 1.9% |
| 3 | 8672 | 1.2% |
| 4 | 6170 | 0.9% |
| 5 | 5115 | 0.7% |
| 6 | 4688 | 0.7% |
| 7 | 4256 | 0.6% |
| Other values (3) | 9447 | 1.3% |
Latin
| Value | Count | Frequency (%) |
| n | 538167 | |
| o | 194149 | 14.6% |
| U | 172912 | 13.0% |
| k | 172912 | 13.0% |
| w | 172912 | 13.0% |
| t | 21237 | 1.6% |
| l | 19431 | 1.5% |
| e | 19431 | 1.5% |
| S | 17625 | 1.3% |
| N | 1806 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2041478 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 538167 | |
| : | 384282 | |
| o | 194149 | 9.5% |
| U | 172912 | 8.5% |
| k | 172912 | 8.5% |
| w | 172912 | 8.5% |
| 0 | 143437 | 7.0% |
| | | 104279 | 5.1% |
| 1 | 25555 | 1.3% |
| t | 21237 | 1.0% |
| Other values (14) | 111636 | 5.5% |
gun_type
Text
MISSING 
| Distinct | 2502 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 99451 |
| Missing (%) | 41.5% |
| Memory size | 1.8 MiB |
Length
| Max length | 5488 |
|---|---|
| Median length | 10 |
| Mean length | 14.433736 |
| Min length | 5 |
Characters and Unicode
| Total characters | 2023985 |
|---|---|
| Distinct characters | 44 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1867 ? |
|---|---|
| Unique (%) | 1.3% |
Sample
| 1st row | 0::Unknown||1::Unknown |
|---|---|
| 2nd row | 0::Handgun||1::Handgun |
| 3rd row | 0::22 LR||1::223 Rem [AR-15] |
| 4th row | 0::Unknown |
| 5th row | 0::Unknown |
| Value | Count | Frequency (%) |
| 0::unknown | 93559 | |
| 0::handgun | 13018 | 8.1% |
| auto | 4773 | 3.0% |
| 0::9mm | 4599 | 2.9% |
| 0::22 | 2602 | 1.6% |
| lr | 2558 | 1.6% |
| 0::unknown||1::unknown | 2410 | 1.5% |
| 0::40 | 2240 | 1.4% |
| sw | 2217 | 1.4% |
| 0::shotgun | 2151 | 1.3% |
| Other values (2722) | 30842 | 19.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 448059 | |
| : | 384499 | |
| 0 | 149516 | 7.4% |
| o | 141293 | 7.0% |
| U | 131154 | 6.5% |
| k | 131154 | 6.5% |
| w | 131154 | 6.5% |
| | | 104403 | 5.2% |
| u | 36648 | 1.8% |
| g | 33261 | 1.6% |
| Other values (34) | 332844 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1035627 | |
| Other Punctuation | 385439 | 19.0% |
| Decimal Number | 275165 | 13.6% |
| Uppercase Letter | 194755 | 9.6% |
| Math Symbol | 104403 | 5.2% |
| Space Separator | 20743 | 1.0% |
| Dash Punctuation | 2747 | 0.1% |
| Open Punctuation | 2553 | 0.1% |
| Close Punctuation | 2553 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 448059 | |
| o | 141293 | 13.6% |
| k | 131154 | 12.7% |
| w | 131154 | 12.7% |
| u | 36648 | 3.5% |
| g | 33261 | 3.2% |
| a | 27531 | 2.7% |
| d | 25050 | 2.4% |
| m | 14635 | 1.4% |
| t | 11204 | 1.1% |
| Other values (7) | 35638 | 3.4% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 149516 | |
| 1 | 28495 | 10.4% |
| 2 | 26517 | 9.6% |
| 3 | 16236 | 5.9% |
| 4 | 12728 | 4.6% |
| 5 | 10539 | 3.8% |
| 9 | 10164 | 3.7% |
| 8 | 8254 | 3.0% |
| 7 | 6965 | 2.5% |
| 6 | 5751 | 2.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 131154 | |
| H | 25050 | 12.9% |
| R | 11855 | 6.1% |
| S | 8915 | 4.6% |
| A | 8421 | 4.3% |
| L | 3358 | 1.7% |
| W | 2975 | 1.5% |
| O | 1065 | 0.5% |
| M | 1022 | 0.5% |
| K | 940 | 0.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 384499 | |
| . | 940 | 0.2% |
Math Symbol
| Value | Count | Frequency (%) |
| | | 104403 |
Space Separator
| Value | Count | Frequency (%) |
| 20743 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2747 |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 2553 |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 2553 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1230382 | |
| Common | 793603 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 448059 | |
| o | 141293 | 11.5% |
| U | 131154 | 10.7% |
| k | 131154 | 10.7% |
| w | 131154 | 10.7% |
| u | 36648 | 3.0% |
| g | 33261 | 2.7% |
| a | 27531 | 2.2% |
| d | 25050 | 2.0% |
| H | 25050 | 2.0% |
| Other values (17) | 100028 | 8.1% |
Common
| Value | Count | Frequency (%) |
| : | 384499 | |
| 0 | 149516 | 18.8% |
| | | 104403 | 13.2% |
| 1 | 28495 | 3.6% |
| 2 | 26517 | 3.3% |
| 20743 | 2.6% | |
| 3 | 16236 | 2.0% |
| 4 | 12728 | 1.6% |
| 5 | 10539 | 1.3% |
| 9 | 10164 | 1.3% |
| Other values (7) | 29763 | 3.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2023985 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 448059 | |
| : | 384499 | |
| 0 | 149516 | 7.4% |
| o | 141293 | 7.0% |
| U | 131154 | 6.5% |
| k | 131154 | 6.5% |
| w | 131154 | 6.5% |
| | | 104403 | 5.2% |
| u | 36648 | 1.8% |
| g | 33261 | 1.6% |
| Other values (34) | 332844 |
| Distinct | 18126 |
|---|---|
| Distinct (%) | 7.6% |
| Missing | 326 |
| Missing (%) | 0.1% |
| Memory size | 1.8 MiB |
Length
| Max length | 761 |
|---|---|
| Median length | 628 |
| Mean length | 82.218098 |
| Min length | 8 |
Characters and Unicode
| Total characters | 19678984 |
|---|---|
| Distinct characters | 64 |
| Distinct categories | 10 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 12168 ? |
|---|---|
| Unique (%) | 5.1% |
Sample
| 1st row | Shot - Wounded/Injured||Mass Shooting (4+ victims injured or killed excluding the subject/suspect/perpetrator, one location)||Possession (gun(s) found during commission of other crimes)||Possession of gun by felon or prohibited person |
|---|---|
| 2nd row | Shot - Wounded/Injured||Shot - Dead (murder, accidental, suicide)||Mass Shooting (4+ victims injured or killed excluding the subject/suspect/perpetrator, one location)||Gang involvement |
| 3rd row | Shot - Wounded/Injured||Shot - Dead (murder, accidental, suicide)||Shots Fired - No Injuries||Bar/club incident - in or around establishment |
| 4th row | Shot - Dead (murder, accidental, suicide)||Officer Involved Incident||Officer Involved Shooting - subject/suspect/perpetrator killed||Drug involvement||Kidnapping/abductions/hostage||Under the influence of alcohol or drugs (only applies to the subject/suspect/perpetrator ) |
| 5th row | Shot - Wounded/Injured||Shot - Dead (murder, accidental, suicide)||Suicide^||Murder/Suicide||Attempted Murder/Suicide (one variable unsuccessful)||Domestic Violence |
| Value | Count | Frequency (%) |
| 244816 | 11.3% | |
| shot | 141035 | 6.5% |
| of | 73576 | 3.4% |
| no | 59089 | 2.7% |
| accidental | 53868 | 2.5% |
| murder | 53507 | 2.5% |
| dead | 53409 | 2.5% |
| wounded/injured | 47541 | 2.2% |
| involved | 44737 | 2.1% |
| found | 43214 | 2.0% |
| Other values (2764) | 1353615 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1929056 | 9.8% | |
| e | 1580812 | 8.0% |
| o | 1482316 | 7.5% |
| n | 1462911 | 7.4% |
| i | 1204643 | 6.1% |
| d | 1058725 | 5.4% |
| r | 1049310 | 5.3% |
| t | 964476 | 4.9% |
| s | 900485 | 4.6% |
| u | 735368 | 3.7% |
| Other values (54) | 7310882 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 14347747 | |
| Space Separator | 1929056 | 9.8% |
| Uppercase Letter | 1551514 | 7.9% |
| Math Symbol | 679388 | 3.5% |
| Other Punctuation | 520467 | 2.6% |
| Dash Punctuation | 318941 | 1.6% |
| Open Punctuation | 158292 | 0.8% |
| Close Punctuation | 158292 | 0.8% |
| Decimal Number | 9943 | 0.1% |
| Modifier Symbol | 5344 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1580812 | |
| o | 1482316 | |
| n | 1462911 | |
| i | 1204643 | 8.4% |
| d | 1058725 | 7.4% |
| r | 1049310 | 7.3% |
| t | 964476 | 6.7% |
| s | 900485 | 6.3% |
| u | 735368 | 5.1% |
| c | 661520 | 4.6% |
| Other values (15) | 3247181 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 301883 | |
| I | 296569 | |
| D | 142763 | |
| N | 106602 | 6.9% |
| A | 102855 | 6.6% |
| W | 101843 | 6.6% |
| P | 60098 | 3.9% |
| F | 53741 | 3.5% |
| O | 50254 | 3.2% |
| G | 49950 | 3.2% |
| Other values (12) | 284956 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 378906 | |
| , | 139476 | 26.8% |
| : | 1478 | 0.3% |
| & | 607 | 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 3787 | |
| 1 | 2052 | |
| 5 | 2052 | |
| 7 | 2052 |
Math Symbol
| Value | Count | Frequency (%) |
| | | 677653 | |
| + | 1735 | 0.3% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 150732 | |
| { | 7560 | 4.8% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 150732 | |
| } | 7560 | 4.8% |
Space Separator
| Value | Count | Frequency (%) |
| 1929056 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 318941 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ^ | 5344 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 15899261 | |
| Common | 3779723 | 19.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1580812 | 9.9% |
| o | 1482316 | 9.3% |
| n | 1462911 | 9.2% |
| i | 1204643 | 7.6% |
| d | 1058725 | 6.7% |
| r | 1049310 | 6.6% |
| t | 964476 | 6.1% |
| s | 900485 | 5.7% |
| u | 735368 | 4.6% |
| c | 661520 | 4.2% |
| Other values (37) | 4798695 |
Common
| Value | Count | Frequency (%) |
| 1929056 | ||
| | | 677653 | 17.9% |
| / | 378906 | 10.0% |
| - | 318941 | 8.4% |
| ( | 150732 | 4.0% |
| ) | 150732 | 4.0% |
| , | 139476 | 3.7% |
| { | 7560 | 0.2% |
| } | 7560 | 0.2% |
| ^ | 5344 | 0.1% |
| Other values (7) | 13763 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 19678984 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1929056 | 9.8% | |
| e | 1580812 | 8.0% |
| o | 1482316 | 7.5% |
| n | 1462911 | 7.4% |
| i | 1204643 | 6.1% |
| d | 1058725 | 5.4% |
| r | 1049310 | 5.3% |
| t | 964476 | 4.9% |
| s | 900485 | 4.6% |
| u | 735368 | 3.7% |
| Other values (54) | 7310882 |
latitude
Real number (ℝ)
MISSING 
| Distinct | 101240 |
|---|---|
| Distinct (%) | 43.7% |
| Missing | 7923 |
| Missing (%) | 3.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.546598 |
| Minimum | 19.1114 |
|---|---|
| Maximum | 71.3368 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 19.1114 |
|---|---|
| 5-th percentile | 29.2205 |
| Q1 | 33.9034 |
| median | 38.5706 |
| Q3 | 41.437375 |
| 95-th percentile | 44.0544 |
| Maximum | 71.3368 |
| Range | 52.2254 |
| Interquartile range (IQR) | 7.533975 |
Descriptive statistics
| Standard deviation | 5.1307632 |
|---|---|
| Coefficient of variation (CV) | 0.13665055 |
| Kurtosis | 1.8789007 |
| Mean | 37.546598 |
| Median Absolute Deviation (MAD) | 3.3471 |
| Skewness | 0.2072284 |
| Sum | 8701574.3 |
| Variance | 26.324731 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33.6356 | 253 | 0.1% |
| 39.294 | 244 | 0.1% |
| 29.9872 | 170 | 0.1% |
| 33.4347 | 161 | 0.1% |
| 32.8982 | 160 | 0.1% |
| 38.9075 | 142 | 0.1% |
| 36.1334 | 112 | < 0.1% |
| 29.9551 | 109 | < 0.1% |
| 28.436 | 109 | < 0.1% |
| 39.8496 | 108 | < 0.1% |
| Other values (101230) | 230186 | |
| (Missing) | 7923 | 3.3% |
| Value | Count | Frequency (%) |
| 19.1114 | 1 | |
| 19.1127 | 1 | |
| 19.2 | 1 | |
| 19.2017 | 1 | |
| 19.4243 | 1 | |
| 19.4331 | 1 | |
| 19.4475 | 1 | |
| 19.4554 | 1 | |
| 19.4578 | 1 | |
| 19.4581 | 1 |
| Value | Count | Frequency (%) |
| 71.3368 | 1 | |
| 71.3005 | 1 | |
| 71.3001 | 1 | |
| 71.3 | 1 | |
| 71.2997 | 1 | |
| 71.2921 | 1 | |
| 71.2906 | 1 | |
| 70.6698 | 1 | |
| 70.1981 | 1 | |
| 67.5533 | 1 |
MISSING 
| Distinct | 27595 |
|---|---|
| Distinct (%) | 65.6% |
| Missing | 197588 |
| Missing (%) | 82.4% |
| Memory size | 1.8 MiB |
Length
| Max length | 100 |
|---|---|
| Median length | 54 |
| Mean length | 17.352657 |
| Min length | 1 |
Characters and Unicode
| Total characters | 730356 |
|---|---|
| Distinct characters | 94 |
| Distinct categories | 13 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 23867 ? |
|---|---|
| Unique (%) | 56.7% |
Sample
| 1st row | Cotton Club |
|---|---|
| 2nd row | Fairmont Terrace |
| 3rd row | Nite Owl Tavern |
| 4th row | Club Venue |
| 5th row | New Castle County courthouse |
| Value | Count | Frequency (%) |
| apartments | 4271 | 3.9% |
| park | 3361 | 3.1% |
| school | 1831 | 1.7% |
| neighborhood | 1407 | 1.3% |
| high | 1196 | 1.1% |
| airport | 1070 | 1.0% |
| inn | 1006 | 0.9% |
| and | 937 | 0.9% |
| bar | 858 | 0.8% |
| club | 848 | 0.8% |
| Other values (14701) | 92848 |
Most occurring characters
| Value | Count | Frequency (%) |
| 67550 | 9.2% | |
| e | 60163 | 8.2% |
| a | 54551 | 7.5% |
| r | 48460 | 6.6% |
| o | 48250 | 6.6% |
| t | 44529 | 6.1% |
| n | 44105 | 6.0% |
| i | 35853 | 4.9% |
| l | 33487 | 4.6% |
| s | 30873 | 4.2% |
| Other values (84) | 262535 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 541059 | |
| Uppercase Letter | 110848 | 15.2% |
| Space Separator | 67560 | 9.3% |
| Other Punctuation | 4528 | 0.6% |
| Decimal Number | 2666 | 0.4% |
| Open Punctuation | 1039 | 0.1% |
| Close Punctuation | 1037 | 0.1% |
| Dash Punctuation | 1035 | 0.1% |
| Final Punctuation | 563 | 0.1% |
| Initial Punctuation | 8 | < 0.1% |
| Other values (3) | 13 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 60163 | |
| a | 54551 | |
| r | 48460 | 9.0% |
| o | 48250 | 8.9% |
| t | 44529 | 8.2% |
| n | 44105 | 8.2% |
| i | 35853 | 6.6% |
| l | 33487 | 6.2% |
| s | 30873 | 5.7% |
| h | 17981 | 3.3% |
| Other values (21) | 122807 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 11831 | 10.7% |
| C | 11000 | 9.9% |
| A | 10048 | 9.1% |
| P | 8802 | 7.9% |
| M | 7686 | 6.9% |
| H | 6667 | 6.0% |
| B | 6057 | 5.5% |
| L | 4856 | 4.4% |
| T | 4765 | 4.3% |
| G | 4479 | 4.0% |
| Other values (16) | 34657 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 2685 | |
| & | 754 | 16.7% |
| . | 535 | 11.8% |
| / | 364 | 8.0% |
| , | 136 | 3.0% |
| " | 30 | 0.7% |
| # | 17 | 0.4% |
| @ | 3 | 0.1% |
| ! | 2 | < 0.1% |
| ; | 1 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 465 | |
| 7 | 427 | |
| 6 | 372 | |
| 2 | 280 | |
| 0 | 254 | |
| 8 | 190 | |
| 4 | 180 | 6.8% |
| 5 | 176 | 6.6% |
| 3 | 170 | 6.4% |
| 9 | 152 | 5.7% |
Space Separator
| Value | Count | Frequency (%) |
| 67550 | ||
| 8 | < 0.1% | |
| 2 | < 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1036 | |
| [ | 3 | 0.3% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1034 | |
| ] | 3 | 0.3% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1029 | |
| – | 6 | 0.6% |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 562 | |
| ” | 1 | 0.2% |
Initial Punctuation
| Value | Count | Frequency (%) |
| ‘ | 7 | |
| “ | 1 | 12.5% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 5 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 4 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 4 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 651907 | |
| Common | 78449 | 10.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 60163 | 9.2% |
| a | 54551 | 8.4% |
| r | 48460 | 7.4% |
| o | 48250 | 7.4% |
| t | 44529 | 6.8% |
| n | 44105 | 6.8% |
| i | 35853 | 5.5% |
| l | 33487 | 5.1% |
| s | 30873 | 4.7% |
| h | 17981 | 2.8% |
| Other values (47) | 233655 |
Common
| Value | Count | Frequency (%) |
| 67550 | ||
| ' | 2685 | 3.4% |
| ( | 1036 | 1.3% |
| ) | 1034 | 1.3% |
| - | 1029 | 1.3% |
| & | 754 | 1.0% |
| ’ | 562 | 0.7% |
| . | 535 | 0.7% |
| 1 | 465 | 0.6% |
| 7 | 427 | 0.5% |
| Other values (27) | 2372 | 3.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 729751 | |
| Punctuation | 585 | 0.1% |
| None | 20 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 67550 | 9.3% | |
| e | 60163 | 8.2% |
| a | 54551 | 7.5% |
| r | 48460 | 6.6% |
| o | 48250 | 6.6% |
| t | 44529 | 6.1% |
| n | 44105 | 6.0% |
| i | 35853 | 4.9% |
| l | 33487 | 4.6% |
| s | 30873 | 4.2% |
| Other values (72) | 261930 |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 562 | |
| 8 | 1.4% | |
| ‘ | 7 | 1.2% |
| – | 6 | 1.0% |
| “ | 1 | 0.2% |
| ” | 1 | 0.2% |
None
| Value | Count | Frequency (%) |
| é | 12 | |
| 2 | 10.0% | |
| ñ | 2 | 10.0% |
| à | 2 | 10.0% |
| á | 1 | 5.0% |
| ó | 1 | 5.0% |
longitude
Real number (ℝ)
MISSING 
| Distinct | 112347 |
|---|---|
| Distinct (%) | 48.5% |
| Missing | 7923 |
| Missing (%) | 3.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -89.338348 |
| Minimum | -171.429 |
|---|---|
| Maximum | 97.4331 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 231749 |
| Negative (%) | 96.7% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | -171.429 |
|---|---|
| 5-th percentile | -121.41635 |
| Q1 | -94.158725 |
| median | -86.2496 |
| Q3 | -80.048625 |
| 95-th percentile | -73.228765 |
| Maximum | 97.4331 |
| Range | 268.8621 |
| Interquartile range (IQR) | 14.1101 |
Descriptive statistics
| Standard deviation | 14.359546 |
|---|---|
| Coefficient of variation (CV) | -0.16073216 |
| Kurtosis | 2.5309184 |
| Mean | -89.338348 |
| Median Absolute Deviation (MAD) | 6.83845 |
| Skewness | -1.3548337 |
| Sum | -20704520 |
| Variance | 206.19655 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -84.4333 | 254 | 0.1% |
| -76.62 | 234 | 0.1% |
| -112.006 | 173 | 0.1% |
| -95.3477 | 169 | 0.1% |
| -97.0404 | 160 | 0.1% |
| -77.0176 | 135 | 0.1% |
| -122.296 | 119 | < 0.1% |
| -104.674 | 113 | < 0.1% |
| -90.0747 | 112 | < 0.1% |
| -81.3065 | 106 | < 0.1% |
| Other values (112337) | 230179 | |
| (Missing) | 7923 | 3.3% |
| Value | Count | Frequency (%) |
| -171.429 | 1 | |
| -166.541 | 1 | |
| -166.097 | 1 | |
| -165.711 | 2 | |
| -165.586 | 1 | |
| -165.509 | 1 | |
| -165.444 | 1 | |
| -164.76 | 1 | |
| -164.621 | 1 | |
| -164.62 | 1 |
| Value | Count | Frequency (%) |
| 97.4331 | 2 | |
| 96.7591 | 1 | |
| 90.37 | 1 | |
| 80.9491 | 1 | |
| -67.2711 | 1 | |
| -67.275 | 1 | |
| -67.2996 | 1 | |
| -67.3318 | 1 | |
| -67.4012 | 1 | |
| -67.7617 | 1 |
n_guns_involved
Real number (ℝ)
MISSING  SKEWED 
| Distinct | 106 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 99451 |
| Missing (%) | 41.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.3724416 |
| Minimum | 1 |
|---|---|
| Maximum | 400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 400 |
| Range | 399 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 4.6782022 |
|---|---|
| Coefficient of variation (CV) | 3.4086712 |
| Kurtosis | 3574.4227 |
| Mean | 1.3724416 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 51.595073 |
| Sum | 192452 |
| Variance | 21.885576 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 127548 | |
| 2 | 7477 | 3.1% |
| 3 | 2021 | 0.8% |
| 4 | 871 | 0.4% |
| 5 | 435 | 0.2% |
| 6 | 285 | 0.1% |
| 7 | 232 | 0.1% |
| 8 | 137 | 0.1% |
| 9 | 111 | < 0.1% |
| 10 | 103 | < 0.1% |
| Other values (96) | 1006 | 0.4% |
| (Missing) | 99451 |
| Value | Count | Frequency (%) |
| 1 | 127548 | |
| 2 | 7477 | 3.1% |
| 3 | 2021 | 0.8% |
| 4 | 871 | 0.4% |
| 5 | 435 | 0.2% |
| 6 | 285 | 0.1% |
| 7 | 232 | 0.1% |
| 8 | 137 | 0.1% |
| 9 | 111 | < 0.1% |
| 10 | 103 | < 0.1% |
| Value | Count | Frequency (%) |
| 400 | 4 | |
| 399 | 1 | < 0.1% |
| 374 | 1 | < 0.1% |
| 346 | 1 | < 0.1% |
| 338 | 1 | < 0.1% |
| 323 | 1 | < 0.1% |
| 300 | 3 | |
| 280 | 1 | < 0.1% |
| 276 | 1 | < 0.1% |
| 268 | 1 | < 0.1% |
notes
Text
MISSING 
| Distinct | 136652 |
|---|---|
| Distinct (%) | 86.1% |
| Missing | 81017 |
| Missing (%) | 33.8% |
| Memory size | 1.8 MiB |
Length
| Max length | 256 |
|---|---|
| Median length | 209 |
| Mean length | 56.068272 |
| Min length | 1 |
Characters and Unicode
| Total characters | 8895792 |
|---|---|
| Distinct characters | 113 |
| Distinct categories | 18 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 4 ? |
Unique
| Unique | 132570 ? |
|---|---|
| Unique (%) | 83.6% |
Sample
| 1st row | Julian Sims under investigation: Four Shot and Injured |
|---|---|
| 2nd row | Four Shot; One Killed; Unidentified shooter in getaway car |
| 3rd row | Two firearms recovered. (Attempted) murder suicide - both succeeded in fulfilling an M/S and did not succeed, based on details. |
| 4th row | Unprovoked drive-by results in multiple teens and young adults injured. No source with names or exact ages. |
| 5th row | Perps were likely motivated by gang affliations |
| Value | Count | Frequency (%) |
| shot | 51224 | 3.5% |
| in | 46684 | 3.2% |
| man | 25376 | 1.7% |
| at | 24903 | 1.7% |
| and | 24760 | 1.7% |
| of | 18355 | 1.2% |
| to | 17653 | 1.2% |
| fired | 17268 | 1.2% |
| gun | 17081 | 1.2% |
| with | 16267 | 1.1% |
| Other values (60021) | 1222138 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1318260 | ||
| e | 699024 | 7.9% |
| o | 539193 | 6.1% |
| t | 528838 | 5.9% |
| n | 526584 | 5.9% |
| a | 487633 | 5.5% |
| i | 476111 | 5.4% |
| r | 457335 | 5.1% |
| s | 439499 | 4.9% |
| d | 317870 | 3.6% |
| Other values (103) | 3105445 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6589180 | |
| Space Separator | 1318265 | 14.8% |
| Decimal Number | 329600 | 3.7% |
| Other Punctuation | 315674 | 3.5% |
| Uppercase Letter | 267473 | 3.0% |
| Control | 36565 | 0.4% |
| Dash Punctuation | 34611 | 0.4% |
| Close Punctuation | 1470 | < 0.1% |
| Open Punctuation | 1469 | < 0.1% |
| Final Punctuation | 718 | < 0.1% |
| Other values (8) | 767 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 699024 | 10.6% |
| o | 539193 | 8.2% |
| t | 528838 | 8.0% |
| n | 526584 | 8.0% |
| a | 487633 | 7.4% |
| i | 476111 | 7.2% |
| r | 457335 | 6.9% |
| s | 439499 | 6.7% |
| d | 317870 | 4.8% |
| h | 288625 | 4.4% |
| Other values (19) | 1828468 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 30463 | 11.4% |
| M | 26064 | 9.7% |
| A | 21984 | 8.2% |
| C | 21369 | 8.0% |
| P | 18338 | 6.9% |
| D | 13668 | 5.1% |
| B | 12989 | 4.9% |
| T | 12066 | 4.5% |
| R | 11687 | 4.4% |
| H | 11011 | 4.1% |
| Other values (17) | 87834 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 136807 | |
| . | 80920 | |
| ; | 61479 | |
| / | 16066 | 5.1% |
| : | 7601 | 2.4% |
| ' | 7516 | 2.4% |
| & | 2416 | 0.8% |
| " | 1562 | 0.5% |
| # | 601 | 0.2% |
| * | 368 | 0.1% |
| Other values (5) | 338 | 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 54168 | |
| 2 | 46098 | |
| 3 | 36140 | |
| 0 | 36123 | |
| 4 | 30328 | |
| 8 | 26860 | |
| 5 | 26670 | |
| 9 | 26217 | |
| 7 | 25028 | |
| 6 | 21968 |
Math Symbol
| Value | Count | Frequency (%) |
| ~ | 213 | |
| + | 82 | 24.2% |
| = | 39 | 11.5% |
| | | 2 | 0.6% |
| > | 2 | 0.6% |
| < | 1 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 1318260 | ||
| 3 | < 0.1% | |
| 2 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 34597 | |
| — | 12 | < 0.1% |
| – | 2 | < 0.1% |
Control
| Value | Count | Frequency (%) |
| 29048 | ||
| 7514 | 20.5% | |
| 3 | < 0.1% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1132 | |
| ] | 337 | 22.9% |
| } | 1 | 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1130 | |
| [ | 339 | 23.1% |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 643 | |
| ” | 75 | 10.4% |
Initial Punctuation
| Value | Count | Frequency (%) |
| “ | 82 | |
| ‘ | 16 | 16.3% |
Other Symbol
| Value | Count | Frequency (%) |
| ° | 9 | |
| ® | 2 | 18.2% |
Format
| Value | Count | Frequency (%) |
| | 1 | |
| | 1 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 264 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 50 |
Other Number
| Value | Count | Frequency (%) |
| ½ | 2 |
Modifier Letter
| Value | Count | Frequency (%) |
| ʻ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6856653 | |
| Common | 2039139 | 22.9% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1318260 | ||
| , | 136807 | 6.7% |
| . | 80920 | 4.0% |
| ; | 61479 | 3.0% |
| 1 | 54168 | 2.7% |
| 2 | 46098 | 2.3% |
| 3 | 36140 | 1.8% |
| 0 | 36123 | 1.8% |
| - | 34597 | 1.7% |
| 4 | 30328 | 1.5% |
| Other values (47) | 204219 | 10.0% |
Latin
| Value | Count | Frequency (%) |
| e | 699024 | 10.2% |
| o | 539193 | 7.9% |
| t | 528838 | 7.7% |
| n | 526584 | 7.7% |
| a | 487633 | 7.1% |
| i | 476111 | 6.9% |
| r | 457335 | 6.7% |
| s | 439499 | 6.4% |
| d | 317870 | 4.6% |
| h | 288625 | 4.2% |
| Other values (46) | 2095941 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8894918 | |
| Punctuation | 834 | < 0.1% |
| None | 39 | < 0.1% |
| Modifier Letters | 1 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1318260 | ||
| e | 699024 | 7.9% |
| o | 539193 | 6.1% |
| t | 528838 | 5.9% |
| n | 526584 | 5.9% |
| a | 487633 | 5.5% |
| i | 476111 | 5.4% |
| r | 457335 | 5.1% |
| s | 439499 | 4.9% |
| d | 317870 | 3.6% |
| Other values (85) | 3104571 |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 643 | |
| “ | 82 | 9.8% |
| ” | 75 | 9.0% |
| ‘ | 16 | 1.9% |
| — | 12 | 1.4% |
| – | 2 | 0.2% |
| 2 | 0.2% | |
| | 1 | 0.1% |
| | 1 | 0.1% |
None
| Value | Count | Frequency (%) |
| é | 13 | |
| ° | 9 | |
| ñ | 8 | |
| 3 | 7.7% | |
| ® | 2 | 5.1% |
| ½ | 2 | 5.1% |
| Ñ | 1 | 2.6% |
| ú | 1 | 2.6% |
Modifier Letters
| Value | Count | Frequency (%) |
| ʻ | 1 |
participant_age
Text
MISSING 
| Distinct | 18951 |
|---|---|
| Distinct (%) | 12.9% |
| Missing | 92298 |
| Missing (%) | 38.5% |
| Memory size | 1.8 MiB |
Length
| Max length | 517 |
|---|---|
| Median length | 5 |
| Mean length | 8.481534 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1250000 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 13962 ? |
|---|---|
| Unique (%) | 9.5% |
Sample
| 1st row | 0::20 |
|---|---|
| 2nd row | 0::20 |
| 3rd row | 0::25||1::31||2::33||3::34||4::33 |
| 4th row | 0::29||1::33||2::56||3::33 |
| 5th row | 0::18||1::46||2::14||3::47 |
| Value | Count | Frequency (%) |
| 0::24 | 3814 | 2.6% |
| 0::23 | 3735 | 2.5% |
| 0::22 | 3733 | 2.5% |
| 0::19 | 3719 | 2.5% |
| 0::21 | 3612 | 2.5% |
| 0::18 | 3536 | 2.4% |
| 0::20 | 3535 | 2.4% |
| 0::25 | 3500 | 2.4% |
| 0::26 | 3277 | 2.2% |
| 0::27 | 3110 | 2.1% |
| Other values (18941) | 111808 |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 440049 | |
| 0 | 155438 | 12.4% |
| | | 147354 | 11.8% |
| 2 | 129127 | 10.3% |
| 1 | 124587 | 10.0% |
| 3 | 71865 | 5.7% |
| 4 | 44217 | 3.5% |
| 5 | 34423 | 2.8% |
| 6 | 27255 | 2.2% |
| 8 | 25721 | 2.1% |
| Other values (2) | 49964 | 4.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 662597 | |
| Other Punctuation | 440049 | |
| Math Symbol | 147354 | 11.8% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 155438 | |
| 2 | 129127 | |
| 1 | 124587 | |
| 3 | 71865 | |
| 4 | 44217 | 6.7% |
| 5 | 34423 | 5.2% |
| 6 | 27255 | 4.1% |
| 8 | 25721 | 3.9% |
| 7 | 25634 | 3.9% |
| 9 | 24330 | 3.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 440049 |
Math Symbol
| Value | Count | Frequency (%) |
| | | 147354 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1250000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| : | 440049 | |
| 0 | 155438 | 12.4% |
| | | 147354 | 11.8% |
| 2 | 129127 | 10.3% |
| 1 | 124587 | 10.0% |
| 3 | 71865 | 5.7% |
| 4 | 44217 | 3.5% |
| 5 | 34423 | 2.8% |
| 6 | 27255 | 2.2% |
| 8 | 25721 | 2.1% |
| Other values (2) | 49964 | 4.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1250000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| : | 440049 | |
| 0 | 155438 | 12.4% |
| | | 147354 | 11.8% |
| 2 | 129127 | 10.3% |
| 1 | 124587 | 10.0% |
| 3 | 71865 | 5.7% |
| 4 | 44217 | 3.5% |
| 5 | 34423 | 2.8% |
| 6 | 27255 | 2.2% |
| 8 | 25721 | 2.1% |
| Other values (2) | 49964 | 4.0% |
MISSING 
| Distinct | 898 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 42119 |
| Missing (%) | 17.6% |
| Memory size | 1.8 MiB |
Length
| Max length | 1536 |
|---|---|
| Median length | 12 |
| Mean length | 21.963312 |
| Min length | 11 |
Characters and Unicode
| Total characters | 4339028 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 488 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 0::Adult 18+||1::Adult 18+||2::Adult 18+||3::Adult 18+||4::Adult 18+ |
|---|---|
| 2nd row | 0::Adult 18+||1::Adult 18+||2::Adult 18+||3::Adult 18+ |
| 3rd row | 0::Adult 18+||1::Adult 18+||2::Adult 18+||3::Adult 18+||4::Adult 18+ |
| 4th row | 0::Adult 18+||1::Adult 18+||2::Adult 18+||3::Adult 18+ |
| 5th row | 0::Adult 18+||1::Adult 18+||2::Teen 12-17||3::Adult 18+ |
| Value | Count | Frequency (%) |
| 18 | 181166 | |
| 0::adult | 172425 | |
| 18+||1::adult | 73182 | |
| 18+||2::adult | 25269 | 4.7% |
| 12-17 | 14623 | 2.7% |
| 0::teen | 13169 | 2.5% |
| 18+||3::adult | 9699 | 1.8% |
| 1::adult | 5320 | 1.0% |
| 18+||4::adult | 3776 | 0.7% |
| 18+||1::teen | 3415 | 0.6% |
| Other values (307) | 32132 | 6.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 666899 | |
| 1 | 459224 | |
| 336618 | ||
| d | 311003 | |
| l | 311003 | |
| 8 | 306769 | |
| A | 306435 | |
| u | 306435 | |
| t | 306435 | |
| + | 306435 | |
| Other values (16) | 721772 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1320857 | |
| Decimal Number | 1066457 | |
| Other Punctuation | 666899 | |
| Math Symbol | 581396 | |
| Space Separator | 336618 | 7.8% |
| Uppercase Letter | 336618 | 7.8% |
| Dash Punctuation | 30183 | 0.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 459224 | |
| 8 | 306769 | |
| 0 | 195930 | |
| 2 | 57349 | 5.4% |
| 7 | 26175 | 2.5% |
| 3 | 12574 | 1.2% |
| 4 | 5075 | 0.5% |
| 5 | 2124 | 0.2% |
| 6 | 1007 | 0.1% |
| 9 | 230 | < 0.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| d | 311003 | |
| l | 311003 | |
| u | 306435 | |
| t | 306435 | |
| e | 51230 | 3.9% |
| n | 25615 | 1.9% |
| h | 4568 | 0.3% |
| i | 4568 | 0.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 306435 | |
| T | 25615 | 7.6% |
| C | 4568 | 1.4% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 306435 | |
| | | 274961 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 666899 |
Space Separator
| Value | Count | Frequency (%) |
| 336618 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 30183 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2681553 | |
| Latin | 1657475 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| : | 666899 | |
| 1 | 459224 | |
| 336618 | ||
| 8 | 306769 | |
| + | 306435 | |
| | | 274961 | |
| 0 | 195930 | 7.3% |
| 2 | 57349 | 2.1% |
| - | 30183 | 1.1% |
| 7 | 26175 | 1.0% |
| Other values (5) | 21010 | 0.8% |
Latin
| Value | Count | Frequency (%) |
| d | 311003 | |
| l | 311003 | |
| A | 306435 | |
| u | 306435 | |
| t | 306435 | |
| e | 51230 | 3.1% |
| T | 25615 | 1.5% |
| n | 25615 | 1.5% |
| C | 4568 | 0.3% |
| h | 4568 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4339028 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| : | 666899 | |
| 1 | 459224 | |
| 336618 | ||
| d | 311003 | |
| l | 311003 | |
| 8 | 306769 | |
| A | 306435 | |
| u | 306435 | |
| t | 306435 | |
| + | 306435 | |
| Other values (16) | 721772 |
MISSING 
| Distinct | 873 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 36362 |
| Missing (%) | 15.2% |
| Memory size | 1.8 MiB |
Length
| Max length | 803 |
|---|---|
| Median length | 624 |
| Mean length | 13.980124 |
| Min length | 6 |
Characters and Unicode
| Total characters | 2842369 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 486 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 0::Male||1::Male||3::Male||4::Female |
|---|---|
| 2nd row | 0::Male |
| 3rd row | 0::Male||1::Male||2::Male||3::Male||4::Male |
| 4th row | 0::Female||1::Male||2::Male||3::Male |
| 5th row | 0::Female||1::Male||2::Male||3::Female |
| Value | Count | Frequency (%) |
| 0::male | 93497 | |
| 0::male||1::male | 43530 | |
| 0::male||1::male||2::male | 12383 | 6.1% |
| 0::female||1::male | 10602 | 5.2% |
| 0::female | 7791 | 3.8% |
| 0::male||1::female | 5130 | 2.5% |
| 0::male||1::male||2::male||3::male | 4333 | 2.1% |
| 1::male | 4168 | 2.1% |
| 0::female||1::male||2::male | 2062 | 1.0% |
| 0::male||1::female||2::male | 1819 | 0.9% |
| Other values (863) | 18001 | 8.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 698742 | |
| e | 395437 | |
| a | 352264 | |
| l | 352264 | |
| M | 309091 | |
| | | 295226 | |
| 0 | 196029 | 6.9% |
| 1 | 99390 | 3.5% |
| m | 43173 | 1.5% |
| F | 43172 | 1.5% |
| Other values (11) | 57581 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1143139 | |
| Other Punctuation | 698743 | |
| Decimal Number | 352997 | 12.4% |
| Uppercase Letter | 352263 | 12.4% |
| Math Symbol | 295226 | 10.4% |
| Space Separator | 1 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 196029 | |
| 1 | 99390 | |
| 2 | 34472 | 9.8% |
| 3 | 13564 | 3.8% |
| 4 | 5322 | 1.5% |
| 5 | 2187 | 0.6% |
| 6 | 991 | 0.3% |
| 7 | 529 | 0.1% |
| 8 | 306 | 0.1% |
| 9 | 207 | 0.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 395437 | |
| a | 352264 | |
| l | 352264 | |
| m | 43173 | 3.8% |
| f | 1 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 698742 | |
| , | 1 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 309091 | |
| F | 43172 | 12.3% |
Math Symbol
| Value | Count | Frequency (%) |
| | | 295226 |
Space Separator
| Value | Count | Frequency (%) |
| 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1495402 | |
| Common | 1346967 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| : | 698742 | |
| | | 295226 | |
| 0 | 196029 | 14.6% |
| 1 | 99390 | 7.4% |
| 2 | 34472 | 2.6% |
| 3 | 13564 | 1.0% |
| 4 | 5322 | 0.4% |
| 5 | 2187 | 0.2% |
| 6 | 991 | 0.1% |
| 7 | 529 | < 0.1% |
| Other values (4) | 515 | < 0.1% |
Latin
| Value | Count | Frequency (%) |
| e | 395437 | |
| a | 352264 | |
| l | 352264 | |
| M | 309091 | |
| m | 43173 | 2.9% |
| F | 43172 | 2.9% |
| f | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2842369 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| : | 698742 | |
| e | 395437 | |
| a | 352264 | |
| l | 352264 | |
| M | 309091 | |
| | | 295226 | |
| 0 | 196029 | 6.9% |
| 1 | 99390 | 3.5% |
| m | 43173 | 1.5% |
| F | 43172 | 1.5% |
| Other values (11) | 57581 | 2.0% |
participant_name
Text
MISSING 
| Distinct | 113488 |
|---|---|
| Distinct (%) | 96.6% |
| Missing | 122253 |
| Missing (%) | 51.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 2152 |
|---|---|
| Median length | 554 |
| Mean length | 29.761914 |
| Min length | 4 |
Characters and Unicode
| Total characters | 3494763 |
|---|---|
| Distinct characters | 94 |
| Distinct categories | 15 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 110585 ? |
|---|---|
| Unique (%) | 94.2% |
Sample
| 1st row | 0::Julian Sims |
|---|---|
| 2nd row | 0::Bernard Gillis |
| 3rd row | 0::Damien Bell||1::Desmen Noble||2::Herman Seagers||3::Ladd Tate Sr||4::Tallis Moore |
| 4th row | 0::Stacie Philbrook||1::Christopher Ratliffe||2::Anthony Ticali||3::Sonny Archuleta |
| 5th row | 0::Danielle Imani Jameison||1::Maurice Eugene Edmonds, Sr.||2::Maurice Edmonds II||3::Sandra Palmer |
| Value | Count | Frequency (%) |
| jr | 4278 | 1.2% |
| 0::michael | 2062 | 0.6% |
| lee | 1982 | 0.5% |
| l | 1829 | 0.5% |
| d | 1812 | 0.5% |
| williams | 1812 | 0.5% |
| johnson | 1652 | 0.5% |
| smith | 1628 | 0.4% |
| a | 1616 | 0.4% |
| j | 1589 | 0.4% |
| Other values (119259) | 346483 |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 358855 | 10.3% |
| e | 259679 | 7.4% |
| 251008 | 7.2% | |
| a | 244437 | 7.0% |
| n | 202010 | 5.8% |
| r | 198777 | 5.7% |
| o | 169272 | 4.8% |
| i | 158096 | 4.5% |
| l | 137607 | 3.9% |
| | | 125788 | 3.6% |
| Other values (84) | 1389234 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2109817 | |
| Uppercase Letter | 442476 | 12.7% |
| Other Punctuation | 379235 | 10.9% |
| Space Separator | 251009 | 7.2% |
| Decimal Number | 181719 | 5.2% |
| Math Symbol | 125788 | 3.6% |
| Dash Punctuation | 3414 | 0.1% |
| Final Punctuation | 776 | < 0.1% |
| Initial Punctuation | 398 | < 0.1% |
| Open Punctuation | 57 | < 0.1% |
| Other values (5) | 74 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 259679 | |
| a | 244437 | |
| n | 202010 | |
| r | 198777 | |
| o | 169272 | 8.0% |
| i | 158096 | 7.5% |
| l | 137607 | 6.5% |
| s | 115005 | 5.5% |
| t | 93988 | 4.5% |
| h | 78578 | 3.7% |
| Other values (19) | 452368 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 48266 | 10.9% |
| M | 37653 | 8.5% |
| D | 35687 | 8.1% |
| C | 31678 | 7.2% |
| S | 29761 | 6.7% |
| A | 28194 | 6.4% |
| R | 27952 | 6.3% |
| B | 25651 | 5.8% |
| T | 22354 | 5.1% |
| L | 22258 | 5.0% |
| Other values (17) | 133022 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 99308 | |
| 1 | 52934 | |
| 2 | 17136 | 9.4% |
| 3 | 6825 | 3.8% |
| 4 | 2849 | 1.6% |
| 5 | 1232 | 0.7% |
| 6 | 618 | 0.3% |
| 7 | 366 | 0.2% |
| 8 | 239 | 0.1% |
| 9 | 212 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 358855 | |
| . | 15062 | 4.0% |
| " | 2789 | 0.7% |
| , | 1363 | 0.4% |
| ' | 1088 | 0.3% |
| / | 69 | < 0.1% |
| * | 5 | < 0.1% |
| & | 3 | < 0.1% |
| • | 1 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3410 | |
| ‑ | 3 | 0.1% |
| – | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 251008 | ||
| 1 | < 0.1% |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 392 | |
| ” | 384 |
Initial Punctuation
| Value | Count | Frequency (%) |
| “ | 387 | |
| ‘ | 11 | 2.8% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 55 | |
| [ | 2 | 3.5% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 55 | |
| ] | 2 | 3.5% |
Format
| Value | Count | Frequency (%) |
| | 6 | |
| | 1 | 14.3% |
Math Symbol
| Value | Count | Frequency (%) |
| | | 125788 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 8 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1 |
Control
| Value | Count | Frequency (%) |
| 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2552293 | |
| Common | 942470 | 27.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 259679 | 10.2% |
| a | 244437 | 9.6% |
| n | 202010 | 7.9% |
| r | 198777 | 7.8% |
| o | 169272 | 6.6% |
| i | 158096 | 6.2% |
| l | 137607 | 5.4% |
| s | 115005 | 4.5% |
| t | 93988 | 3.7% |
| h | 78578 | 3.1% |
| Other values (46) | 894844 |
Common
| Value | Count | Frequency (%) |
| : | 358855 | |
| 251008 | ||
| | | 125788 | 13.3% |
| 0 | 99308 | 10.5% |
| 1 | 52934 | 5.6% |
| 2 | 17136 | 1.8% |
| . | 15062 | 1.6% |
| 3 | 6825 | 0.7% |
| - | 3410 | 0.4% |
| 4 | 2849 | 0.3% |
| Other values (28) | 9295 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3493562 | |
| Punctuation | 1179 | < 0.1% |
| None | 22 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| : | 358855 | 10.3% |
| e | 259679 | 7.4% |
| 251008 | 7.2% | |
| a | 244437 | 7.0% |
| n | 202010 | 5.8% |
| r | 198777 | 5.7% |
| o | 169272 | 4.8% |
| i | 158096 | 4.5% |
| l | 137607 | 3.9% |
| | | 125788 | 3.6% |
| Other values (70) | 1388033 |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 392 | |
| “ | 387 | |
| ” | 384 | |
| ‘ | 11 | 0.9% |
| ‑ | 3 | 0.3% |
| • | 1 | 0.1% |
| – | 1 | 0.1% |
None
| Value | Count | Frequency (%) |
| ñ | 11 | |
| | 6 | |
| | 1 | 4.5% |
| ç | 1 | 4.5% |
| 1 | 4.5% | |
| Á | 1 | 4.5% |
| ó | 1 | 4.5% |
MISSING 
| Distinct | 284 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 223903 |
| Missing (%) | 93.4% |
| Memory size | 1.8 MiB |
Length
| Max length | 366 |
|---|---|
| Median length | 274 |
| Mean length | 27.692976 |
| Min length | 8 |
Characters and Unicode
| Total characters | 436829 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 124 ? |
|---|---|
| Unique (%) | 0.8% |
Sample
| 1st row | 3::Family |
|---|---|
| 2nd row | 5::Family |
| 3rd row | 4::Drive by - Random victims||5::Drive by - Random victims||6::Drive by - Random victims |
| 4th row | 7::Aquaintance |
| 5th row | 5::Gang vs Gang||6::Gang vs Gang |
| Value | Count | Frequency (%) |
| 5442 | 9.9% | |
| robbery | 4704 | 8.6% |
| 1::armed | 3521 | 6.4% |
| others | 3471 | 6.3% |
| current | 3471 | 6.3% |
| or | 3471 | 6.3% |
| former | 3456 | 6.3% |
| 1::significant | 2658 | 4.8% |
| 1::family | 2573 | 4.7% |
| perp | 1912 | 3.5% |
| Other values (216) | 20167 |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 41054 | 9.4% |
| r | 40823 | 9.3% |
| 39072 | 8.9% | |
| e | 34562 | 7.9% |
| o | 27960 | 6.4% |
| i | 22723 | 5.2% |
| n | 20544 | 4.7% |
| m | 18927 | 4.3% |
| b | 16711 | 3.8% |
| t | 14804 | 3.4% |
| Other values (41) | 159649 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 281438 | |
| Other Punctuation | 41054 | 9.4% |
| Uppercase Letter | 39564 | 9.1% |
| Space Separator | 39072 | 8.9% |
| Decimal Number | 20574 | 4.7% |
| Math Symbol | 9544 | 2.2% |
| Dash Punctuation | 5583 | 1.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 40823 | |
| e | 34562 | |
| o | 27960 | |
| i | 22723 | 8.1% |
| n | 20544 | 7.3% |
| m | 18927 | 6.7% |
| b | 16711 | 5.9% |
| t | 14804 | 5.3% |
| a | 12257 | 4.4% |
| y | 11573 | 4.1% |
| Other values (13) | 60554 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 8989 | |
| R | 8028 | |
| F | 4650 | |
| S | 3471 | 8.8% |
| N | 2101 | 5.3% |
| P | 1912 | 4.8% |
| K | 1912 | 4.8% |
| V | 1912 | 4.8% |
| I | 1899 | 4.8% |
| H | 1899 | 4.8% |
| Other values (4) | 2791 | 7.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 12266 | |
| 2 | 3768 | 18.3% |
| 0 | 2291 | 11.1% |
| 3 | 1432 | 7.0% |
| 4 | 520 | 2.5% |
| 5 | 176 | 0.9% |
| 6 | 63 | 0.3% |
| 7 | 29 | 0.1% |
| 8 | 18 | 0.1% |
| 9 | 11 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 41054 |
Space Separator
| Value | Count | Frequency (%) |
| 39072 |
Math Symbol
| Value | Count | Frequency (%) |
| | | 9544 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5583 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 321002 | |
| Common | 115827 | 26.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 40823 | |
| e | 34562 | 10.8% |
| o | 27960 | 8.7% |
| i | 22723 | 7.1% |
| n | 20544 | 6.4% |
| m | 18927 | 5.9% |
| b | 16711 | 5.2% |
| t | 14804 | 4.6% |
| a | 12257 | 3.8% |
| y | 11573 | 3.6% |
| Other values (27) | 100118 |
Common
| Value | Count | Frequency (%) |
| : | 41054 | |
| 39072 | ||
| 1 | 12266 | 10.6% |
| | | 9544 | 8.2% |
| - | 5583 | 4.8% |
| 2 | 3768 | 3.3% |
| 0 | 2291 | 2.0% |
| 3 | 1432 | 1.2% |
| 4 | 520 | 0.4% |
| 5 | 176 | 0.2% |
| Other values (4) | 121 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 436829 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| : | 41054 | 9.4% |
| r | 40823 | 9.3% |
| 39072 | 8.9% | |
| e | 34562 | 7.9% |
| o | 27960 | 6.4% |
| i | 22723 | 5.2% |
| n | 20544 | 4.7% |
| m | 18927 | 4.3% |
| b | 16711 | 3.8% |
| t | 14804 | 3.4% |
| Other values (41) | 159649 |
MISSING 
| Distinct | 2150 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 27626 |
| Missing (%) | 11.5% |
| Memory size | 1.8 MiB |
Length
| Max length | 1500 |
|---|---|
| Median length | 746 |
| Mean length | 24.29358 |
| Min length | 8 |
Characters and Unicode
| Total characters | 5151478 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1181 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | 0::Arrested||1::Injured||2::Injured||3::Injured||4::Injured |
|---|---|
| 2nd row | 0::Killed||1::Injured||2::Injured||3::Injured |
| 3rd row | 0::Injured, Unharmed, Arrested||1::Unharmed, Arrested||2::Killed||3::Injured||4::Injured |
| 4th row | 0::Killed||1::Killed||2::Killed||3::Killed |
| 5th row | 0::Injured||1::Injured||2::Killed||3::Killed |
| Value | Count | Frequency (%) |
| arrested | 62404 | |
| 0::unharmed | 46059 | |
| 0::injured | 44095 | |
| 0::injured||1::unharmed | 22189 | 7.4% |
| 0::killed | 21265 | 7.1% |
| 0::killed||1::unharmed | 14657 | 4.9% |
| 0::unharmed||1::unharmed | 9826 | 3.3% |
| arrested||1::unharmed | 8755 | 2.9% |
| arrested||2::unharmed | 7947 | 2.6% |
| 0::injured||1::injured | 6473 | 2.1% |
| Other values (1177) | 57636 |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 752047 | |
| e | 567922 | 11.0% |
| r | 507444 | 9.9% |
| d | 468589 | 9.1% |
| | | 331209 | 6.4% |
| n | 308778 | 6.0% |
| 0 | 208732 | 4.1% |
| U | 190383 | 3.7% |
| h | 190383 | 3.7% |
| a | 190383 | 3.7% |
| Other values (21) | 1435608 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3040772 | |
| Other Punctuation | 841302 | 16.3% |
| Uppercase Letter | 468589 | 9.1% |
| Decimal Number | 380351 | 7.4% |
| Math Symbol | 331209 | 6.4% |
| Space Separator | 89255 | 1.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 567922 | |
| r | 507444 | |
| d | 468589 | |
| n | 308778 | |
| h | 190383 | 6.3% |
| a | 190383 | 6.3% |
| m | 190383 | 6.3% |
| l | 120956 | 4.0% |
| u | 118395 | 3.9% |
| j | 118395 | 3.9% |
| Other values (3) | 259144 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 208732 | |
| 1 | 106989 | |
| 2 | 38041 | 10.0% |
| 3 | 15281 | 4.0% |
| 4 | 6156 | 1.6% |
| 5 | 2578 | 0.7% |
| 6 | 1220 | 0.3% |
| 7 | 673 | 0.2% |
| 8 | 397 | 0.1% |
| 9 | 284 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 190383 | |
| I | 118395 | |
| A | 99333 | |
| K | 60478 | 12.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 752047 | |
| , | 89255 | 10.6% |
Math Symbol
| Value | Count | Frequency (%) |
| | | 331209 |
Space Separator
| Value | Count | Frequency (%) |
| 89255 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3509361 | |
| Common | 1642117 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 567922 | |
| r | 507444 | |
| d | 468589 | |
| n | 308778 | |
| U | 190383 | 5.4% |
| h | 190383 | 5.4% |
| a | 190383 | 5.4% |
| m | 190383 | 5.4% |
| l | 120956 | 3.4% |
| u | 118395 | 3.4% |
| Other values (7) | 655745 |
Common
| Value | Count | Frequency (%) |
| : | 752047 | |
| | | 331209 | |
| 0 | 208732 | 12.7% |
| 1 | 106989 | 6.5% |
| 89255 | 5.4% | |
| , | 89255 | 5.4% |
| 2 | 38041 | 2.3% |
| 3 | 15281 | 0.9% |
| 4 | 6156 | 0.4% |
| 5 | 2578 | 0.2% |
| Other values (4) | 2574 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5151478 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| : | 752047 | |
| e | 567922 | 11.0% |
| r | 507444 | 9.9% |
| d | 468589 | 9.1% |
| | | 331209 | 6.4% |
| n | 308778 | 6.0% |
| 0 | 208732 | 4.1% |
| U | 190383 | 3.7% |
| h | 190383 | 3.7% |
| a | 190383 | 3.7% |
| Other values (21) | 1435608 |
participant_type
Text
MISSING 
| Distinct | 259 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 24863 |
| Missing (%) | 10.4% |
| Memory size | 1.8 MiB |
Length
| Max length | 1311 |
|---|---|
| Median length | 1236 |
| Mean length | 26.395221 |
| Min length | 8 |
Characters and Unicode
| Total characters | 5670063 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 96 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0::Victim||1::Victim||2::Victim||3::Victim||4::Subject-Suspect |
|---|---|
| 2nd row | 0::Victim||1::Victim||2::Victim||3::Victim||4::Subject-Suspect |
| 3rd row | 0::Subject-Suspect||1::Subject-Suspect||2::Victim||3::Victim||4::Victim |
| 4th row | 0::Victim||1::Victim||2::Victim||3::Subject-Suspect |
| 5th row | 0::Victim||1::Victim||2::Victim||3::Subject-Suspect |
| Value | Count | Frequency (%) |
| 0::victim | 58564 | |
| 0::victim||1::subject-suspect | 50579 | |
| 0::subject-suspect | 44914 | |
| 0::victim||1::subject-suspect||2::subject-suspect | 10941 | 5.1% |
| 0::victim||1::victim | 9033 | 4.2% |
| 0::subject-suspect||1::subject-suspect | 8922 | 4.2% |
| 0::victim||1::victim||2::subject-suspect | 6552 | 3.1% |
| 0::victim||1::subject-suspect||2::subject-suspect||3::subject-suspect | 3720 | 1.7% |
| 0::subject-suspect||1::subject-suspect||2::subject-suspect | 3040 | 1.4% |
| 0::victim||1::victim||2::subject-suspect||3::subject-suspect | 2107 | 1.0% |
| Other values (249) | 16442 | 7.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 777836 | |
| c | 591586 | |
| t | 591586 | |
| S | 398526 | 7.0% |
| u | 398526 | 7.0% |
| e | 398526 | 7.0% |
| i | 386120 | 6.8% |
| | | 351532 | 6.2% |
| 0 | 215020 | 3.8% |
| p | 199263 | 3.5% |
| Other values (15) | 1361542 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3356456 | |
| Other Punctuation | 777836 | 13.7% |
| Uppercase Letter | 591586 | 10.4% |
| Decimal Number | 393390 | 6.9% |
| Math Symbol | 351532 | 6.2% |
| Dash Punctuation | 199263 | 3.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 591586 | |
| t | 591586 | |
| u | 398526 | |
| e | 398526 | |
| i | 386120 | |
| p | 199263 | 5.9% |
| s | 199263 | 5.9% |
| j | 199263 | 5.9% |
| b | 199263 | 5.9% |
| m | 193060 | 5.8% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 215020 | |
| 1 | 110860 | |
| 2 | 39613 | 10.1% |
| 3 | 15996 | 4.1% |
| 4 | 6478 | 1.6% |
| 5 | 2721 | 0.7% |
| 6 | 1287 | 0.3% |
| 7 | 702 | 0.2% |
| 8 | 417 | 0.1% |
| 9 | 296 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 398526 | |
| V | 193060 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 777836 |
Math Symbol
| Value | Count | Frequency (%) |
| | | 351532 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 199263 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3948042 | |
| Common | 1722021 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| : | 777836 | |
| | | 351532 | |
| 0 | 215020 | 12.5% |
| - | 199263 | 11.6% |
| 1 | 110860 | 6.4% |
| 2 | 39613 | 2.3% |
| 3 | 15996 | 0.9% |
| 4 | 6478 | 0.4% |
| 5 | 2721 | 0.2% |
| 6 | 1287 | 0.1% |
| Other values (3) | 1415 | 0.1% |
Latin
| Value | Count | Frequency (%) |
| c | 591586 | |
| t | 591586 | |
| S | 398526 | |
| u | 398526 | |
| e | 398526 | |
| i | 386120 | |
| p | 199263 | 5.0% |
| s | 199263 | 5.0% |
| j | 199263 | 5.0% |
| b | 199263 | 5.0% |
| Other values (2) | 386120 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5670063 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| : | 777836 | |
| c | 591586 | |
| t | 591586 | |
| S | 398526 | 7.0% |
| u | 398526 | 7.0% |
| e | 398526 | 7.0% |
| i | 386120 | 6.8% |
| | | 351532 | 6.2% |
| 0 | 215020 | 3.8% |
| p | 199263 | 3.5% |
| Other values (15) | 1361542 |
sources
Text
| Distinct | 217280 |
|---|---|
| Distinct (%) | 90.9% |
| Missing | 609 |
| Missing (%) | 0.3% |
| Memory size | 1.8 MiB |
Length
| Max length | 3015 |
|---|---|
| Median length | 1227 |
| Mean length | 132.79768 |
| Min length | 8 |
Characters and Unicode
| Total characters | 31747675 |
|---|---|
| Distinct characters | 86 |
| Distinct categories | 10 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 208428 ? |
|---|---|
| Unique (%) | 87.2% |
Sample
| 1st row | http://pittsburgh.cbslocal.com/2013/01/01/4-people-shot-in-mckeesport/||http://www.wtae.com/news/local/allegheny/U-S-Marshals-task-force-arrests-New-Year-s-party-shooting-suspect/17977588||http://www.post-gazette.com/local/south/2013/01/17/Man-arrested-in-New-Year-s-Eve-shooting-in-McKeesport/stories/201301170275 |
|---|---|
| 2nd row | http://losangeles.cbslocal.com/2013/01/01/man-killed-3-wounded-at-nye-party-in-hawthorne/||http://latimesblogs.latimes.com/lanow/2013/01/hawthorne-new-year-party-three-killed.html||https://usgunviolence.wordpress.com/2013/01/01/killed-man-hawthorne-ca/||http://www.dailybulletin.com/article/zz/20130105/NEWS/130109127 |
| 3rd row | http://www.morningjournal.com/general-news/20130222/lorain-man-pleads-innocent-to-new-years-murder||http://chronicle.northcoastnow.com/2013/02/14/2-men-indicted-in-new-years-day-lorain-murder/ |
| 4th row | http://denver.cbslocal.com/2013/01/06/officer-told-neighbor-standoff-gunman-was-on-meth-binge/||http://www.westword.com/news/sonny-archuleta-triple-murder-in-aurora-guns-purchased-legally-55-57-5900504||http://www.denverpost.com/ci_22322380/aurora-shooter-was-frenetic-talented-neighbor-says||http://www.dailymail.co.uk/news/article-2258008/Sonny-Archuleta-Gunman-left-dead-latest-Aurora-shooting-lost-brother-gun-violence.html||http://www.dailydemocrat.com/20130106/aurora-shootout-killer-was-frenetic-talented-neighbor-says |
| 5th row | http://myfox8.com/2013/01/08/update-mother-shot-14-year-old-son-two-others-before-killing-herself/||http://myfox8.com/2013/01/07/police-respond-to-report-of-triple-shooting-in-greensboro/||http://www.journalnow.com/news/local/article_d4c723e8-5a0f-11e2-a1fa-0019bb30f31a.html |
| Value | Count | Frequency (%) |
| http://blog.tsa.gov | 1179 | 0.5% |
| http://callsforservice.jaxsheriff.org | 802 | 0.3% |
| https://data.oaklandnet.com/public-safety/crimewatch-maps-past-90-days/ym6k-rx7a | 491 | 0.2% |
| http://itmdapps.ci.mil.wi.us/mpdcalldata/currentcadcalls/callsservice.faces | 327 | 0.1% |
| http://www.springsgov.com/units/police/policeblotter.asp | 224 | 0.1% |
| https://www.facebook.com/pg/policeclips/posts/?ref=page_internal | 124 | 0.1% |
| http://www.tampabay.com/news/hillsborough/crime | 107 | < 0.1% |
| http://blog.tsa.gov/search | 87 | < 0.1% |
| https://www.montereysheriff.org/mcsologs/dpl.pdf | 84 | < 0.1% |
| https://www.springsgov.com/units/police/policeblotter.asp | 78 | < 0.1% |
| Other values (217262) | 235565 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 2184150 | 6.9% |
| - | 2176370 | 6.9% |
| e | 2083789 | 6.6% |
| / | 2030216 | 6.4% |
| o | 1860015 | 5.9% |
| n | 1609263 | 5.1% |
| s | 1479276 | 4.7% |
| i | 1433344 | 4.5% |
| a | 1415467 | 4.5% |
| w | 1243029 | 3.9% |
| Other values (76) | 14232756 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 22655559 | |
| Other Punctuation | 3158871 | 9.9% |
| Decimal Number | 3114108 | 9.8% |
| Dash Punctuation | 2176370 | 6.9% |
| Uppercase Letter | 236225 | 0.7% |
| Math Symbol | 225530 | 0.7% |
| Connector Punctuation | 180859 | 0.6% |
| Open Punctuation | 71 | < 0.1% |
| Close Punctuation | 69 | < 0.1% |
| Currency Symbol | 13 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 2184150 | 9.6% |
| e | 2083789 | 9.2% |
| o | 1860015 | 8.2% |
| n | 1609263 | 7.1% |
| s | 1479276 | 6.5% |
| i | 1433344 | 6.3% |
| a | 1415467 | 6.2% |
| w | 1243029 | 5.5% |
| r | 1216178 | 5.4% |
| c | 1182658 | 5.2% |
| Other values (16) | 6948390 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 27243 | 11.5% |
| P | 18898 | 8.0% |
| C | 16146 | 6.8% |
| N | 15212 | 6.4% |
| M | 13967 | 5.9% |
| D | 13875 | 5.9% |
| A | 12833 | 5.4% |
| W | 12621 | 5.3% |
| E | 11282 | 4.8% |
| F | 9850 | 4.2% |
| Other values (16) | 84298 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 2030216 | |
| . | 738511 | 23.4% |
| : | 335577 | 10.6% |
| # | 16191 | 0.5% |
| ? | 13325 | 0.4% |
| & | 11922 | 0.4% |
| % | 9048 | 0.3% |
| , | 3402 | 0.1% |
| ! | 434 | < 0.1% |
| ; | 209 | < 0.1% |
| Other values (3) | 36 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 523990 | |
| 0 | 492305 | |
| 2 | 448660 | |
| 3 | 262415 | |
| 5 | 254938 | |
| 4 | 242476 | |
| 6 | 238398 | |
| 7 | 236397 | |
| 8 | 209882 | |
| 9 | 204647 | 6.6% |
Math Symbol
| Value | Count | Frequency (%) |
| | | 189629 | |
| = | 25185 | 11.2% |
| + | 10677 | 4.7% |
| ~ | 39 | < 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 54 | |
| ( | 17 | 23.9% |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 52 | |
| ) | 17 | 24.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2176370 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 180859 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 13 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 22891784 | |
| Common | 8855891 | 27.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 2184150 | 9.5% |
| e | 2083789 | 9.1% |
| o | 1860015 | 8.1% |
| n | 1609263 | 7.0% |
| s | 1479276 | 6.5% |
| i | 1433344 | 6.3% |
| a | 1415467 | 6.2% |
| w | 1243029 | 5.4% |
| r | 1216178 | 5.3% |
| c | 1182658 | 5.2% |
| Other values (42) | 7184615 |
Common
| Value | Count | Frequency (%) |
| - | 2176370 | |
| / | 2030216 | |
| . | 738511 | 8.3% |
| 1 | 523990 | 5.9% |
| 0 | 492305 | 5.6% |
| 2 | 448660 | 5.1% |
| : | 335577 | 3.8% |
| 3 | 262415 | 3.0% |
| 5 | 254938 | 2.9% |
| 4 | 242476 | 2.7% |
| Other values (24) | 1350433 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 31747675 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 2184150 | 6.9% |
| - | 2176370 | 6.9% |
| e | 2083789 | 6.6% |
| / | 2030216 | 6.4% |
| o | 1860015 | 5.9% |
| n | 1609263 | 5.1% |
| s | 1479276 | 4.7% |
| i | 1433344 | 4.5% |
| a | 1415467 | 4.5% |
| w | 1243029 | 3.9% |
| Other values (76) | 14232756 |
state_house_district
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 275 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 38772 |
| Missing (%) | 16.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55.447132 |
| Minimum | 1 |
|---|---|
| Maximum | 901 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 21 |
| median | 47 |
| Q3 | 84 |
| 95-th percentile | 134 |
| Maximum | 901 |
| Range | 900 |
| Interquartile range (IQR) | 63 |
Descriptive statistics
| Standard deviation | 42.048117 |
|---|---|
| Coefficient of variation (CV) | 0.75834611 |
| Kurtosis | 17.431432 |
| Mean | 55.447132 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 1.8224792 |
| Sum | 11139606 |
| Variance | 1768.0441 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18 | 3476 | 1.5% |
| 10 | 3411 | 1.4% |
| 32 | 3218 | 1.3% |
| 31 | 3192 | 1.3% |
| 3 | 3064 | 1.3% |
| 2 | 2941 | 1.2% |
| 34 | 2897 | 1.2% |
| 6 | 2870 | 1.2% |
| 13 | 2762 | 1.2% |
| 29 | 2680 | 1.1% |
| Other values (265) | 170394 | |
| (Missing) | 38772 | 16.2% |
| Value | Count | Frequency (%) |
| 1 | 2056 | |
| 2 | 2941 | |
| 3 | 3064 | |
| 4 | 1928 | |
| 5 | 2603 | |
| 6 | 2870 | |
| 7 | 2059 | |
| 8 | 2475 | |
| 9 | 2492 | |
| 10 | 3411 |
| Value | Count | Frequency (%) |
| 901 | 1 | |
| 814 | 1 | |
| 813 | 1 | |
| 811 | 1 | |
| 809 | 1 | |
| 808 | 1 | |
| 805 | 1 | |
| 804 | 1 | |
| 801 | 1 | |
| 729 | 2 |
state_senate_district
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 68 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 32335 |
| Missing (%) | 13.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.47711 |
| Minimum | 1 |
|---|---|
| Maximum | 94 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 9 |
| median | 19 |
| Q3 | 30 |
| 95-th percentile | 46 |
| Maximum | 94 |
| Range | 93 |
| Interquartile range (IQR) | 21 |
Descriptive statistics
| Standard deviation | 14.20456 |
|---|---|
| Coefficient of variation (CV) | 0.69367989 |
| Kurtosis | -0.24424374 |
| Mean | 20.47711 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.63840614 |
| Sum | 4245765 |
| Variance | 201.76951 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 10041 | 4.2% |
| 9 | 7963 | 3.3% |
| 3 | 7837 | 3.3% |
| 4 | 7328 | 3.1% |
| 2 | 6666 | 2.8% |
| 15 | 5835 | 2.4% |
| 6 | 5817 | 2.4% |
| 19 | 5644 | 2.4% |
| 14 | 5641 | 2.4% |
| 11 | 5620 | 2.3% |
| Other values (58) | 138950 | |
| (Missing) | 32335 | 13.5% |
| Value | Count | Frequency (%) |
| 1 | 5206 | |
| 2 | 6666 | |
| 3 | 7837 | |
| 4 | 7328 | |
| 5 | 10041 | |
| 6 | 5817 | |
| 7 | 4742 | |
| 8 | 3962 | 1.7% |
| 9 | 7963 | |
| 10 | 4542 |
| Value | Count | Frequency (%) |
| 94 | 1 | < 0.1% |
| 67 | 69 | < 0.1% |
| 66 | 33 | < 0.1% |
| 65 | 124 | 0.1% |
| 64 | 20 | < 0.1% |
| 63 | 867 | |
| 62 | 350 | |
| 61 | 177 | 0.1% |
| 60 | 204 | 0.1% |
| 59 | 487 |
| congressional_district | incident_id | latitude | longitude | n_guns_involved | n_injured | n_killed | state_house_district | state_senate_district | |
|---|---|---|---|---|---|---|---|---|---|
| congressional_district | 1.000 | 0.006 | -0.167 | -0.033 | -0.001 | -0.009 | 0.043 | 0.231 | 0.343 |
| incident_id | 0.006 | 1.000 | 0.023 | -0.021 | -0.062 | 0.017 | 0.007 | -0.020 | -0.009 |
| latitude | -0.167 | 0.023 | 1.000 | 0.152 | 0.029 | 0.000 | -0.100 | -0.264 | -0.016 |
| longitude | -0.033 | -0.021 | 0.152 | 1.000 | 0.012 | 0.025 | -0.072 | 0.154 | 0.092 |
| n_guns_involved | -0.001 | -0.062 | 0.029 | 0.012 | 1.000 | -0.119 | -0.084 | -0.000 | 0.007 |
| n_injured | -0.009 | 0.017 | 0.000 | 0.025 | -0.119 | 1.000 | -0.256 | -0.040 | -0.058 |
| n_killed | 0.043 | 0.007 | -0.100 | -0.072 | -0.084 | -0.256 | 1.000 | -0.001 | -0.003 |
| state_house_district | 0.231 | -0.020 | -0.264 | 0.154 | -0.000 | -0.040 | -0.001 | 1.000 | 0.508 |
| state_senate_district | 0.343 | -0.009 | -0.016 | 0.092 | 0.007 | -0.058 | -0.003 | 0.508 | 1.000 |
| incident_id | date | state | city_or_county | address | n_killed | n_injured | incident_url | source_url | incident_url_fields_missing | congressional_district | gun_stolen | gun_type | incident_characteristics | latitude | location_description | longitude | n_guns_involved | notes | participant_age | participant_age_group | participant_gender | participant_name | participant_relationship | participant_status | participant_type | sources | state_house_district | state_senate_district | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 461105 | 2013-01-01 | Pennsylvania | Mckeesport | 1506 Versailles Avenue and Coursin Street | 0 | 4 | http://www.gunviolencearchive.org/incident/461105 | http://www.post-gazette.com/local/south/2013/01/17/Man-arrested-in-New-Year-s-Eve-shooting-in-McKeesport/stories/201301170275 | False | 14.0 | NaN | NaN | Shot - Wounded/Injured||Mass Shooting (4+ victims injured or killed excluding the subject/suspect/perpetrator, one location)||Possession (gun(s) found during commission of other crimes)||Possession of gun by felon or prohibited person | 40.3467 | NaN | -79.8559 | NaN | Julian Sims under investigation: Four Shot and Injured | 0::20 | 0::Adult 18+||1::Adult 18+||2::Adult 18+||3::Adult 18+||4::Adult 18+ | 0::Male||1::Male||3::Male||4::Female | 0::Julian Sims | NaN | 0::Arrested||1::Injured||2::Injured||3::Injured||4::Injured | 0::Victim||1::Victim||2::Victim||3::Victim||4::Subject-Suspect | http://pittsburgh.cbslocal.com/2013/01/01/4-people-shot-in-mckeesport/||http://www.wtae.com/news/local/allegheny/U-S-Marshals-task-force-arrests-New-Year-s-party-shooting-suspect/17977588||http://www.post-gazette.com/local/south/2013/01/17/Man-arrested-in-New-Year-s-Eve-shooting-in-McKeesport/stories/201301170275 | NaN | NaN |
| 1 | 460726 | 2013-01-01 | California | Hawthorne | 13500 block of Cerise Avenue | 1 | 3 | http://www.gunviolencearchive.org/incident/460726 | http://www.dailybulletin.com/article/zz/20130105/NEWS/130109127 | False | 43.0 | NaN | NaN | Shot - Wounded/Injured||Shot - Dead (murder, accidental, suicide)||Mass Shooting (4+ victims injured or killed excluding the subject/suspect/perpetrator, one location)||Gang involvement | 33.9090 | NaN | -118.3330 | NaN | Four Shot; One Killed; Unidentified shooter in getaway car | 0::20 | 0::Adult 18+||1::Adult 18+||2::Adult 18+||3::Adult 18+ | 0::Male | 0::Bernard Gillis | NaN | 0::Killed||1::Injured||2::Injured||3::Injured | 0::Victim||1::Victim||2::Victim||3::Victim||4::Subject-Suspect | http://losangeles.cbslocal.com/2013/01/01/man-killed-3-wounded-at-nye-party-in-hawthorne/||http://latimesblogs.latimes.com/lanow/2013/01/hawthorne-new-year-party-three-killed.html||https://usgunviolence.wordpress.com/2013/01/01/killed-man-hawthorne-ca/||http://www.dailybulletin.com/article/zz/20130105/NEWS/130109127 | 62.0 | 35.0 |
| 2 | 478855 | 2013-01-01 | Ohio | Lorain | 1776 East 28th Street | 1 | 3 | http://www.gunviolencearchive.org/incident/478855 | http://chronicle.northcoastnow.com/2013/02/14/2-men-indicted-in-new-years-day-lorain-murder/ | False | 9.0 | 0::Unknown||1::Unknown | 0::Unknown||1::Unknown | Shot - Wounded/Injured||Shot - Dead (murder, accidental, suicide)||Shots Fired - No Injuries||Bar/club incident - in or around establishment | 41.4455 | Cotton Club | -82.1377 | 2.0 | NaN | 0::25||1::31||2::33||3::34||4::33 | 0::Adult 18+||1::Adult 18+||2::Adult 18+||3::Adult 18+||4::Adult 18+ | 0::Male||1::Male||2::Male||3::Male||4::Male | 0::Damien Bell||1::Desmen Noble||2::Herman Seagers||3::Ladd Tate Sr||4::Tallis Moore | NaN | 0::Injured, Unharmed, Arrested||1::Unharmed, Arrested||2::Killed||3::Injured||4::Injured | 0::Subject-Suspect||1::Subject-Suspect||2::Victim||3::Victim||4::Victim | http://www.morningjournal.com/general-news/20130222/lorain-man-pleads-innocent-to-new-years-murder||http://chronicle.northcoastnow.com/2013/02/14/2-men-indicted-in-new-years-day-lorain-murder/ | 56.0 | 13.0 |
| 3 | 478925 | 2013-01-05 | Colorado | Aurora | 16000 block of East Ithaca Place | 4 | 0 | http://www.gunviolencearchive.org/incident/478925 | http://www.dailydemocrat.com/20130106/aurora-shootout-killer-was-frenetic-talented-neighbor-says | False | 6.0 | NaN | NaN | Shot - Dead (murder, accidental, suicide)||Officer Involved Incident||Officer Involved Shooting - subject/suspect/perpetrator killed||Drug involvement||Kidnapping/abductions/hostage||Under the influence of alcohol or drugs (only applies to the subject/suspect/perpetrator ) | 39.6518 | NaN | -104.8020 | NaN | NaN | 0::29||1::33||2::56||3::33 | 0::Adult 18+||1::Adult 18+||2::Adult 18+||3::Adult 18+ | 0::Female||1::Male||2::Male||3::Male | 0::Stacie Philbrook||1::Christopher Ratliffe||2::Anthony Ticali||3::Sonny Archuleta | NaN | 0::Killed||1::Killed||2::Killed||3::Killed | 0::Victim||1::Victim||2::Victim||3::Subject-Suspect | http://denver.cbslocal.com/2013/01/06/officer-told-neighbor-standoff-gunman-was-on-meth-binge/||http://www.westword.com/news/sonny-archuleta-triple-murder-in-aurora-guns-purchased-legally-55-57-5900504||http://www.denverpost.com/ci_22322380/aurora-shooter-was-frenetic-talented-neighbor-says||http://www.dailymail.co.uk/news/article-2258008/Sonny-Archuleta-Gunman-left-dead-latest-Aurora-shooting-lost-brother-gun-violence.html||http://www.dailydemocrat.com/20130106/aurora-shootout-killer-was-frenetic-talented-neighbor-says | 40.0 | 28.0 |
| 4 | 478959 | 2013-01-07 | North Carolina | Greensboro | 307 Mourning Dove Terrace | 2 | 2 | http://www.gunviolencearchive.org/incident/478959 | http://www.journalnow.com/news/local/article_d4c723e8-5a0f-11e2-a1fa-0019bb30f31a.html | False | 6.0 | 0::Unknown||1::Unknown | 0::Handgun||1::Handgun | Shot - Wounded/Injured||Shot - Dead (murder, accidental, suicide)||Suicide^||Murder/Suicide||Attempted Murder/Suicide (one variable unsuccessful)||Domestic Violence | 36.1140 | NaN | -79.9569 | 2.0 | Two firearms recovered. (Attempted) murder suicide - both succeeded in fulfilling an M/S and did not succeed, based on details. | 0::18||1::46||2::14||3::47 | 0::Adult 18+||1::Adult 18+||2::Teen 12-17||3::Adult 18+ | 0::Female||1::Male||2::Male||3::Female | 0::Danielle Imani Jameison||1::Maurice Eugene Edmonds, Sr.||2::Maurice Edmonds II||3::Sandra Palmer | 3::Family | 0::Injured||1::Injured||2::Killed||3::Killed | 0::Victim||1::Victim||2::Victim||3::Subject-Suspect | http://myfox8.com/2013/01/08/update-mother-shot-14-year-old-son-two-others-before-killing-herself/||http://myfox8.com/2013/01/07/police-respond-to-report-of-triple-shooting-in-greensboro/||http://www.journalnow.com/news/local/article_d4c723e8-5a0f-11e2-a1fa-0019bb30f31a.html | 62.0 | 27.0 |
| 5 | 478948 | 2013-01-07 | Oklahoma | Tulsa | 6000 block of South Owasso | 4 | 0 | http://www.gunviolencearchive.org/incident/478948 | http://usnews.nbcnews.com/_news/2013/01/07/16397584-police-four-women-found-dead-in-tulsa-okla-apartment?lite | False | 1.0 | NaN | NaN | Shot - Dead (murder, accidental, suicide)||Home Invasion||Home Invasion - Resident killed||Mass Shooting (4+ victims injured or killed excluding the subject/suspect/perpetrator, one location)||Armed robbery with injury/death and/or evidence of DGU found | 36.2405 | Fairmont Terrace | -95.9768 | NaN | NaN | 0::23||1::23||2::33||3::55 | 0::Adult 18+||1::Adult 18+||2::Adult 18+||3::Adult 18+||4::Adult 18+||5::Adult 18+ | 0::Female||1::Female||2::Female||3::Female||4::Male||5::Male | 0::Rebeika Powell||1::Kayetie Melchor||2::Misty Nunley||3::Julie Jackson||4::James Poore||5::Cedric Poore | NaN | 0::Killed||1::Killed||2::Killed||3::Killed||4::Unharmed, Arrested||5::Unharmed, Arrested | 0::Victim||1::Victim||2::Victim||3::Victim||4::Subject-Suspect||5::Subject-Suspect | http://www.kjrh.com/news/local-news/4-found-shot-inside-apartment-in-tulsa||http://www.cbsnews.com/news/tulsa-apartment-murders-update-hearing-scheduled-for-brothers-charged-in-quadruple-killing/||http://www.kjrh.com/news/local-news/hearing-continues-for-fairmont-terrace-quadruple-homicide-suspect-cedric-poore-james-poore||http://www.kjrh.com/news/local-news/hearing-for-quadruple-murder-suspects-continue||http://usnews.nbcnews.com/_news/2013/01/07/16397584-police-four-women-found-dead-in-tulsa-okla-apartment?lite | 72.0 | 11.0 |
| 6 | 479363 | 2013-01-19 | New Mexico | Albuquerque | 2806 Long Lane | 5 | 0 | http://www.gunviolencearchive.org/incident/479363 | http://hinterlandgazette.com/2013/01/pastor-greg-griego-identified-victims-killed-nehemiah-griego-albuquerque-nm-shooting.html | False | 1.0 | 0::Unknown||1::Unknown | 0::22 LR||1::223 Rem [AR-15] | Shot - Dead (murder, accidental, suicide)||Mass Shooting (4+ victims injured or killed excluding the subject/suspect/perpetrator, one location)||Domestic Violence | 34.9791 | NaN | -106.7160 | 2.0 | NaN | 0::51||1::40||2::9||3::5||4::2||5::15 | 0::Adult 18+||1::Adult 18+||2::Child 0-11||3::Child 0-11||4::Child 0-11||5::Teen 12-17 | 0::Male||1::Female||2::Male||3::Female||4::Female||5::Male | 0::Greg Griego||1::Sara Griego||2::Zephania Griego||3::Jael Griego||4::Angelina Griego||5::Nehemiah Griego | 5::Family | 0::Killed||1::Killed||2::Killed||3::Killed||4::Killed||5::Unharmed, Arrested | 0::Victim||1::Victim||2::Victim||3::Victim||4::Victim||5::Subject-Suspect | http://www.cbsnews.com/news/nehemiah-gringo-case-memorial-service-planned-for-family-allegedly-slain-by-new-mexico-teen/||http://www.thewire.com/national/2013/01/teenager-reportedly-used-ar-15-kill-five-new-mexico/61199/||http://bigstory.ap.org/article/officials-nm-teen-gunman-kills-5-inside-home||http://www.huffingtonpost.com/2013/01/21/nehemiah-griego-teen-shoots-parents-3-children_n_2519359.html||http://murderpedia.org/male.G/g/griego-nehemiah.htm||http://hinterlandgazette.com/2013/01/pastor-greg-griego-identified-victims-killed-nehemiah-griego-albuquerque-nm-shooting.html | 10.0 | 14.0 |
| 7 | 479374 | 2013-01-21 | Louisiana | New Orleans | LaSalle Street and Martin Luther King Jr. Boulevard | 0 | 5 | http://www.gunviolencearchive.org/incident/479374 | http://www.nola.com/crime/index.ssf/2013/01/nopd_4_people_shot_in_central.html | False | 2.0 | NaN | NaN | Shot - Wounded/Injured||Drive-by (car to street, car to car)||Mass Shooting (4+ victims injured or killed excluding the subject/suspect/perpetrator, one location) | 29.9435 | NaN | -90.0836 | NaN | Unprovoked drive-by results in multiple teens and young adults injured. No source with names or exact ages. | NaN | NaN | 0::Male||1::Male||2::Male||3::Male||4::Male | NaN | NaN | 0::Injured||1::Injured||2::Injured||3::Injured||4::Injured | 0::Victim||1::Victim||2::Victim||3::Victim||4::Victim||5::Subject-Suspect | http://www.huffingtonpost.com/2013/01/21/new-orleans-mlk-day-shooting_n_2521750.html||http://www.fox8live.com/story/20640921/nopd-4-shot-alomg||http://www.nola.com/crime/index.ssf/2013/01/nopd_4_people_shot_in_central.html | 93.0 | 5.0 |
| 8 | 479389 | 2013-01-21 | California | Brentwood | 1100 block of Breton Drive | 0 | 4 | http://www.gunviolencearchive.org/incident/479389 | http://sanfrancisco.cbslocal.com/2013/01/22/4-teens-hurt-in-drive-by-shooting-in-brentwood/ | False | 9.0 | NaN | NaN | Shot - Wounded/Injured||Drive-by (car to street, car to car)||Mass Shooting (4+ victims injured or killed excluding the subject/suspect/perpetrator, one location)||Gang involvement | 37.9656 | NaN | -121.7180 | NaN | Perps were likely motivated by gang affliations | NaN | 0::Teen 12-17||1::Teen 12-17||2::Teen 12-17||4::Adult 18+ | 0::Male||1::Male||2::Male||3::Male||4::Male | NaN | NaN | 0::Injured||1::Injured||2::Injured||3::Injured||4::Unharmed | 0::Victim||1::Victim||2::Victim||3::Victim||4::Subject-Suspect | http://www.contracostatimes.com/ci_22426767/brentwood-teens-may-have-been-shot-over-nike||http://sanfrancisco.cbslocal.com/2013/01/22/4-teens-hurt-in-drive-by-shooting-in-brentwood/ | 11.0 | 7.0 |
| 9 | 492151 | 2013-01-23 | Maryland | Baltimore | 1500 block of W. Fayette St. | 1 | 6 | http://www.gunviolencearchive.org/incident/492151 | http://www.abc2news.com/news/crime-checker/baltimore-city-crime/mother-of-murdered-15-yo-speaks-out | False | 7.0 | NaN | NaN | Shot - Wounded/Injured||Shot - Dead (murder, accidental, suicide)||Mass Shooting (4+ victims injured or killed excluding the subject/suspect/perpetrator, one location) | 39.2899 | NaN | -76.6412 | NaN | Shooting occurred over illegal dice game; victim was killed as he sat on a stoop. Victim was not a participant in the game. | 0::15 | 0::Teen 12-17||1::Adult 18+||2::Adult 18+||3::Adult 18+||4::Adult 18+||5::Adult 18+||6::Adult 18+ | 0::Male | 0::Deshaun Jones | NaN | 0::Killed||1::Injured||2::Injured||3::Injured||4::Injured||5::Injured||6::Injured | 0::Victim||1::Victim||2::Victim||3::Victim||4::Victim||5::Victim||6::Victim | http://articles.baltimoresun.com/2013-08-25/news/bs-md-ci-shootings-20130824_1_west-baltimore-15-year-old-boy-shooting-incidents||http://baltimore.cbslocal.com/2013/08/25/juvenile-dead-6-shot-after-dice-game-goes-bad/||http://www.abc2news.com/news/crime-checker/baltimore-city-crime/mother-of-murdered-15-yo-speaks-out | NaN | 44.0 |
| incident_id | date | state | city_or_county | address | n_killed | n_injured | incident_url | source_url | incident_url_fields_missing | congressional_district | gun_stolen | gun_type | incident_characteristics | latitude | location_description | longitude | n_guns_involved | notes | participant_age | participant_age_group | participant_gender | participant_name | participant_relationship | participant_status | participant_type | sources | state_house_district | state_senate_district | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 239667 | 1082234 | 2018-03-31 | Tennessee | Memphis | 2900 block of Wingate | 0 | 1 | http://www.gunviolencearchive.org/incident/1082234 | http://wreg.com/2018/03/31/one-person-in-critical-condition-after-a-shooting-near-frayser/ | False | 9.0 | 0::Unknown | 0::Unknown | Shot - Wounded/Injured||Domestic Violence | 35.2045 | NaN | -89.9872 | 1.0 | NaN | 0::69||1::35 | 0::Adult 18+||1::Adult 18+ | 0::Male||1::Female | 1::Nicole McKinney | NaN | 0::Injured||1::Arrested | 0::Victim||1::Subject-Suspect | http://wreg.com/2018/03/31/one-person-in-critical-condition-after-a-shooting-near-frayser/ | 90.0 | 30.0 |
| 239668 | 1081742 | 2018-03-31 | Michigan | Detroit | I-96 | 0 | 1 | http://www.gunviolencearchive.org/incident/1081742 | https://www.freep.com/story/news/local/michigan/wayne/2018/03/31/party-bus-shooting-detroit/475537002/ | False | NaN | 0::Unknown | 0::Unknown | Shot - Wounded/Injured||Drive-by (car to street, car to car) | NaN | NaN | NaN | 1.0 | near Wyoming St | NaN | NaN | 0::Male | NaN | NaN | 0::Injured | 0::Victim | https://www.freep.com/story/news/local/michigan/wayne/2018/03/31/party-bus-shooting-detroit/475537002/ | NaN | NaN |
| 239669 | 1082990 | 2018-03-31 | Wisconsin | Madison | Hayes Rd | 0 | 0 | http://www.gunviolencearchive.org/incident/1082990 | https://www.channel3000.com/news/crime/couple-finds-evidence-of-gunfire-after-reports-of-shots-fired-in-area/724111486 | False | NaN | 0::Unknown | 0::45 Auto | Shots Fired - No Injuries | NaN | NaN | NaN | 1.0 | .45 shell casing recovered | NaN | NaN | NaN | NaN | NaN | NaN | NaN | http://host.madison.com/wsj/news/local/crime/gunfire-reported-on-east-side-nobody-hurt-madison-police-say/article_a621b2db-60ff-5f00-94f6-b3aa80711e99.html||https://www.channel3000.com/news/crime/couple-finds-evidence-of-gunfire-after-reports-of-shots-fired-in-area/724111486 | NaN | NaN |
| 239670 | 1081752 | 2018-03-31 | Illinois | Chicago | 1 block of N Paulina St | 0 | 1 | http://www.gunviolencearchive.org/incident/1081752 | https://chicago.suntimes.com/news/man-36-wounded-in-shooting-on-near-west-side/ | False | NaN | 0::Unknown | 0::Unknown | Shot - Wounded/Injured | NaN | NaN | NaN | 1.0 | Rt. leg, good; walk-up by 1; | 0::36 | 0::Adult 18+||1::Adult 18+ | 0::Male||1::Male | NaN | NaN | 0::Injured||1::Unharmed | 0::Victim||1::Subject-Suspect | https://chicago.suntimes.com/news/man-36-wounded-in-shooting-on-near-west-side/ | NaN | NaN |
| 239671 | 1082061 | 2018-03-31 | Washington | Spokane (Spokane Valley) | 12600 block of N Willow Crest Ln | 0 | 0 | http://www.gunviolencearchive.org/incident/1082061 | https://www.kxly.com/news/domestic-violence-suspect-arrested-after-swat-team-standoff/723525275 | False | 5.0 | 0::Unknown | 0::Unknown | Non-Shooting Incident||Possession (gun(s) found during commission of other crimes) | 47.6638 | NaN | -117.2350 | 1.0 | DV call leads to seizure of firearms during arrest. No injuries. | 0::48 | 0::Adult 18+ | 0::Male | 0::Sean M. Gummow | NaN | 0::Unharmed, Arrested | 0::Subject-Suspect | https://www.kxly.com/news/domestic-violence-suspect-arrested-after-swat-team-standoff/723525275 | 4.0 | 4.0 |
| 239672 | 1083142 | 2018-03-31 | Louisiana | Rayne | North Riceland Road and Highway 90 | 0 | 0 | http://www.gunviolencearchive.org/incident/1083142 | http://www.klfy.com/news/local/rayne-woman-charged-with-attemped-murder-for-shooting-at-victim-trying-to-visit-children/1094165597 | False | NaN | 0::Unknown | 0::Unknown | Shots Fired - No Injuries | NaN | NaN | NaN | 1.0 | NaN | 0::25 | 0::Adult 18+ | 0::Female | 0::Jhkeya Tezeno | NaN | 0::Unharmed, Arrested | 0::Subject-Suspect | http://www.klfy.com/news/local/rayne-woman-charged-with-attemped-murder-for-shooting-at-victim-trying-to-visit-children/1094165597 | NaN | NaN |
| 239673 | 1083139 | 2018-03-31 | Louisiana | Natchitoches | 247 Keyser Ave | 1 | 0 | http://www.gunviolencearchive.org/incident/1083139 | http://www.ksla.com/story/37854648/man-wanted-in-connection-with-natchitoches-parish-shooting-surrenders | False | 4.0 | 0::Unknown | 0::Unknown | Shot - Dead (murder, accidental, suicide)||Institution/Group/Business | 31.7537 | Shop Rite | -93.0836 | 1.0 | NaN | 1::21 | 0::Adult 18+||1::Adult 18+ | 0::Male||1::Male | 0::Jamal Haskett||1::Jaquarious Tyjuan Ardison | NaN | 0::Killed||1::Unharmed, Arrested | 0::Victim||1::Subject-Suspect | http://www.ksla.com/story/37854648/man-wanted-in-connection-with-natchitoches-parish-shooting-surrenders | 23.0 | 31.0 |
| 239674 | 1083151 | 2018-03-31 | Louisiana | Gretna | 1300 block of Cook Street | 0 | 1 | http://www.gunviolencearchive.org/incident/1083151 | http://www.nola.com/crime/index.ssf/2018/04/shooting_reported_on_st_charle.html#incart_river_index | False | 2.0 | 0::Unknown | 0::Unknown | Shot - Wounded/Injured | 29.9239 | NaN | -90.0442 | 1.0 | NaN | 0::21 | 0::Adult 18+ | 0::Male | NaN | NaN | 0::Injured | 0::Victim | http://www.nola.com/crime/index.ssf/2018/04/shooting_reported_on_st_charle.html#incart_river_index | 85.0 | 7.0 |
| 239675 | 1082514 | 2018-03-31 | Texas | Houston | 12630 Ashford Point Dr | 1 | 0 | http://www.gunviolencearchive.org/incident/1082514 | https://www.chron.com/news/houston-texas/houston/article/Man-found-shot-in-car-in-Houston-s-Westside-12799287.php | False | 9.0 | 0::Unknown | 0::Unknown | Shot - Dead (murder, accidental, suicide) | 29.7201 | Vanderbilt Court apartments | -95.6110 | 1.0 | Vic was found shot to death in car on 4/1/18, apartment complex | 0::42 | 0::Adult 18+ | 0::Male | 0::Leroy Ellis | NaN | 0::Killed | 0::Victim | http://www.khou.com/article/news/hpd-investigating-after-man-found-dead-in-car-on-easter-sunday/285-534039633||https://www.chron.com/news/houston-texas/houston/article/Man-found-shot-in-car-in-Houston-s-Westside-12799287.php | 149.0 | 17.0 |
| 239676 | 1081940 | 2018-03-31 | Maine | Norridgewock | 434 Skowhegan Rd | 2 | 0 | http://www.gunviolencearchive.org/incident/1081940 | https://www.centralmaine.com/2018/03/31/police-say-two-norridgewock-deaths-appear-to-be-murder-suicide/ | False | 2.0 | 0::Unknown||1::Unknown | 0::Handgun||1::Shotgun | Shot - Dead (murder, accidental, suicide)||Suicide^||Murder/Suicide||Domestic Violence | 44.7293 | NaN | -69.7691 | 2.0 | ALT: US 2, shot wife then self, handgun, shotgun recover from home | 0::58||1::62 | 0::Adult 18+||1::Adult 18+ | 0::Female||1::Male | 0::Marie Lancaster Hale||1::William Hale | 1::Significant others - current or former | 0::Killed||1::Killed | 0::Victim||1::Subject-Suspect | https://www.centralmaine.com/2018/03/31/police-say-two-norridgewock-deaths-appear-to-be-murder-suicide/ | 111.0 | 3.0 |